Index Match Issue

Options

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

  • SteyJ
    SteyJ ✭✭✭✭✭✭
    Answer ✓
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!