Forum Discussion
Solved
INDEX & MATCH returning incorrect column data
Hi, See attached file. I am trying to use INDEX and MATCH formula to return the value from the correct column in the Original tab. For some reason the formula is working for other businesses and ret...
=-INDEX(Original!$A$2:$L$235,MATCH(D62,Original!$A$2:$A$235,0),MATCH(A62,Original!$A$2:$L$2,0))
MATCH(lookup_value, lookup_array, [match_type])
Does it work if you add [match_type] = 0 (highlighted in red in the formula) for an exact match?
=-INDEX(Original!$A$2:$L$235,MATCH(D62,Original!$A$2:$A$235,0),MATCH(A62,Original!$A$2:$L$2,0))
MATCH(lookup_value, lookup_array, [match_type])
Does it work if you add [match_type] = 0 (highlighted in red in the formula) for an exact match?
Yes it does! Can't believe that was all it was. Thank you so much!