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.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!