Index Match - Just when I thought I had it figured out

So I am using a formula on a smartsheet, works flawlessly:

=IFERROR(INDEX({PERFECTION YARD CHECK TAG}, MATCH(VIN@row, {PERFECTION YARD CHECK VIN}, 0)), "")

I use it on a few different customer sheets and it works on them.

Then on one sheet - I get this error - it has to be something with how the sheet is set up I think.

Any suggestions ?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!