Matching and indexing

  • Thread starter Thread starter sjnohl
  • Start date Start date
S

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
 
The INDEX function takes a parameter for rows and columns eg
=Index(A2:D4,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(B2:D4,MATCH(C6,A2:A4,0),MATCH(D6,B1:D1,0))
 
Back
Top