Index and Match returns one incorrect response...all others correct
I have a service request sheet with an index/match formula to assign a person based on request type. My formula works for all request types except "External Communications" - it assigns the wrong person. I tried creating a new "Assigned To Lookup" reference sheet, manually entering all fields, and yet the error persists.
=INDEX({Assigned To Lookup Range 1}, MATCH([Request Type]@row, {Assigned To Lookup Range 2}))
Best Answer
-
Try:
=INDEX({Assigned To Lookup Range 1}, MATCH([Request Type]@row, {Assigned To Lookup Range 2}, 0))
The 0 says your list isn't sorted so it needs to find an exact match.
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Try:
=INDEX({Assigned To Lookup Range 1}, MATCH([Request Type]@row, {Assigned To Lookup Range 2}, 0))
The 0 says your list isn't sorted so it needs to find an exact match.
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
@Mark Cronk Yes! Thank you! It was driving me nuts trying to figure out why it wasn't working. Our comms team thanks you! -Gabby
-
Hi Gabby, Glad you found a solution. Thank you for contributing to the community and for the vote up.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!