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 returning the correct value, but for this particular business it is pulling in the data in column 1 and not in the Consumer column. Any idea why it is not liking it? I thought the lookup value in column A would drive the column it returns using the MATCH formula. I checked for any spaces in the cells but there aren't any and I have ran out of ideas.
=-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!
