Issue with INDEX MATCH

Options

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!!

Andrea Zenner

Program Manager | Infrastructure & Operations

Apogee Enterprises

EAP | Mobilizer | Core Product Certified | Superstar

azenner@apog.com

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!