Index Match Issue

sabbott00

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.

SteyJ

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)), "")

SteyJ

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)), "")

sabbott00

Jacob,

That worked thank you!

SteyJ

https://community.smartsheet.com/discussion/comment/419525#Comment_419525

Happy to help!