Index(Match()) Returning incorrect row
![krsch88](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
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!
Best Answer
-
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.
Answers
-
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.
-
Excellent, that did the trick! Thank you so much for your help!
-
Great to hear. Thanks for letting me know.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!