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))
No comments:
Post a Comment