Can you use Index Match to search and match a cell with multiple, comma delineated values?
I have a column containing cells with multiple comma delineated values (image 1) and I want to match any/all of these values to a two column array in a separate reference sheet (image 2) and return the corresponding description from a single column array from the same reference sheet (image 3) into the product column (image 4).
Answers
-
@wrighk22
Smartsheet doesn’t directly support using INDEX MATCH to match multiple comma-separated values in a single cell against a reference sheet. A workaround is to split the comma-separated values into individual rows using a helper sheet or external tool like Excel. Once split, you can use INDEX MATCH or VLOOKUP to match each value to the reference sheet's CFN or GTIN column and return the corresponding description. After matching, combine the results back into a single cell using the JOIN function. This approach ensures accurate matches for all values while maintaining clarity in your data. Let me know if you’d like more details!
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!