Index(Match(Contains)
I'm trying to do an index(match where my search cell sometimes has multiple values (consultant column is a multi-select dropdown). I want to do an index match to report the company of that consultant or consultants. If there are two consultants they will always be from the same company. The below is returning and error. I'm not sure where to go.
=INDEX({Company}, MATCH(CONTAINS(Consultant@row, @cell), {consultant1}, 0))
Best Answer
-
I had almost the same issue recently and got a good solution in this post:
Answers
-
I had almost the same issue recently and got a good solution in this post:
-
@Jamesvan5 - thanks a ton, this worked. I think i was using different search terms when I was looking through the community. Greatly appreciate you directing me to the answer!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!