Index/Match Results Return only matching first entry on list
I"m using Index match to return a contact based on the department entered in another cell. The department entries are copied from the drop down list in the other sheet so they should be exact matches. For some reason it's only returning a value for the first entry on the list, but the others give a "no match" error.
This is the formula I use: =INDEX({Department Contact List Range 1}, MATCH([Component or Support Department]@row, {Department Contact List Range 2}), 0)
screenshots attached below:
Best Answer
-
Move the second to last closing parenthesis to the very end.
You have:
), 0)
Try instead:
, 0))
Answers
-
Move the second to last closing parenthesis to the very end.
You have:
), 0)
Try instead:
, 0))
-
That worked! How embarrassing! thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 369 Global Discussions
- 202 Industry Talk
- 433 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 280 Events
- 31 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!