Index(Match()) Returning incorrect row

krsch88

Hello! I'm hoping to get some help in finding an error in my index(match()) formula. I'm trying to pull a contact name for a customer from one sheet into another based on the customer name.

The original sheet has customer name and contact email; the sheet I'm trying to fill in has customer name and I'd just want to fill it in with contact email using index(match()). When I separate out the index() part of the formula, it works perfectly. I can see the customer listed on row 597, so my formula is =INDEX({Customer Tracking Sheet Contact}, 597), which returns the correct contact person.

Formula:

Customer listed (twice) on customer tracking sheet - rows 597 & 598. The contact person is the same on both rows.

Now, when I try the match() portion of the formula by itself, that seems to be where the issue is located, my formula here is =MATCH(District@row, {Customer Tracking Sheet Customer Name}), which in this case, returns the number 5, indicating row 5, which is not the correct customer.

Not the customer that matches in row 5 (we know this should be 597):

My full formula is =INDEX({Customer Tracking Sheet Contact}, MATCH(District@row, {Customer Tracking Sheet Customer Name}))

Any thoughts on how I can fix this so the match portion works correctly? Thanks in advance!

KPH

Hi

Can you try adding a ,0 at the end of your MATCH

=INDEX({Customer Tracking Sheet Contact}, MATCH(District@row, {Customer Tracking Sheet Customer Name},0))

This will force an exact match.

KPH

Hi

Can you try adding a ,0 at the end of your MATCH

=INDEX({Customer Tracking Sheet Contact}, MATCH(District@row, {Customer Tracking Sheet Customer Name},0))

This will force an exact match.

krsch88

Excellent, that did the trick! Thank you so much for your help!

KPH

Great to hear. Thanks for letting me know.