Issue with INDEX MATCH

Andrea Zenner

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

Paul Newcome

Try using a zero for the third portion of the MATCH function to specify an exact match.

Paul Newcome

Try using a zero for the third portion of the MATCH function to specify an exact match.

Andrea Zenner

@Paul Newcome That fixed it! Thanks!

Paul Newcome

Happy to help. 👍️