Index Match Issue
I have an index/match formula pulling data from a column based on item ID, which is a unique identifier. The index/match today pulled values for every value after the desired ID. Here's the formula text:
=IFERROR(INDEX({North America CAR Tracker Update Request Range 4}, MATCH([ID Number]@row, {North America CAR Tracker Update Request - ID}, 1), 0), "")
It is a column, formula, and the ranges selected are the entire columns in the lookup sheet. I made identical formulas for 3 other functions with this same text and did not have any errors happen, so I'm not sure why this one is not working. Any feedback would be greatly appreciated.
Thank you.
Best Answer
-
It looks like you're using an optional column index. Try without it:
=IFERROR(INDEX({North America CAR Tracker Update Request Range 4}, MATCH([ID Number]@row, {North America CAR Tracker Update Request - ID}, 0)), "")
Sincerely,
Jacob Stey
Answers
-
It looks like you're using an optional column index. Try without it:
=IFERROR(INDEX({North America CAR Tracker Update Request Range 4}, MATCH([ID Number]@row, {North America CAR Tracker Update Request - ID}, 0)), "")
Sincerely,
Jacob Stey
-
Jacob,
That worked thank you!
-
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!