Matching and indexing

[sjnohl]

I am trying to pull data from an array using index + match. All of the
examples that I have found show matching only on 1 column. I am trying
to match on 2 columns. Would appreciate help - Thanks

 

[JS]

The INDEX function takes a parameter for rows and columns eg
=Index(A24,rownum,colnum)
Use MATCH for the rownum & colnum as below. Then in C6 enter the row to
match and in D6 the column to match

=INDEX(B24,MATCH(C6,A2:A4,0),MATCH(D6,B11,0))