How Does Smartsheet Handle Duplicates in INDEX/MATCH? Sorting for Accurate Results

Answers
-
Hi, Haley. INDEX/MATCH will return the FIRST match that is found. If you have multiple matches, you'd be better off using a JOIN/COLLECT formula.
=JOIN(COLLECT({Active Award Data Range 1}, {Active Award Data Range 2}, [Active SIT awards]@row), CHAR(10))
A couple of notes: You may need to swap Active Award Data Range 1 and Active Award Data Range 2 in this formula. Not sure, because I don't know how you've defined those ranges. But just a heads up as a possible troubleshoot if this does not work as written.
Also, the CHAR(10) at the end forces each result onto its own line in the cell. You will want to wrap the text in those cells / that column. But, if you don't want this, the CHAR(10) function is optional - just delete.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!