Excel: Getting FALSE, when the value is in the row array

microsoft excelworksheet-function

I have a table where I want to pull data based on the row and column labels. So I'm using the INDEX MATCH with arrays in the MATCH function but I keep getting a #N/A because b1:d1=d1 is FALSE. Why is this?

    1 2 3  
Jan x x o  
Feb x x x  
Mar x x x

The value I want is in the cell with "o" so I'm using
INDEX(B2:D4, MATCH(1,(B2:D2=B2)*(B2:D2=D2), 0))

Best Answer

To return o in your example above you would need

=INDEX(B2:D4,MATCH("Jan",A2:A4,0),MATCH(3,B1:D1,0))
Related Question