Issue with INDEX MATCH

Hello Everyone,

I have an index match formula that only works for the first row in my sheet and I have no idea why. The first row brings in the right value, all the other rows come back with #NO MATCH.

There is data to be pulled back for the other rows and a VLOOKUP works. What am I missing?


Thanks!!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!