Index/Match Returning No Match When it Has A Match

Kelly Pratt

I keep running into issues in one of my SS environments where the Index Match function is returning a #NO MATCH. What's interesting is I will have it in one column in a sheet and it works, then in the next column I am using the same formula but the only difference is I am changing the INDEX range which then produces a NO MATCH. This doesn't make sense to me since it's working on the first one.

In another scenario, I am using the Index/Match in a column formula and it works in one row but not the next when I am literally copying and pasting the value to match to from the sheet I am looking at.

Any ideas why this could be occurring?

Here is the formula I use:

=INDEX({Program}, MATCH([Project Name]@row, {Intake Project Name}), 0)

Kelly Pratt

Figured this out - my ',0 needs to be before the first parenthesis.

=INDEX({Program}, MATCH([Project Name]@row, {Intake Project Name},0))

Kelly Pratt

Figured this out - my ',0 needs to be before the first parenthesis.

=INDEX({Program}, MATCH([Project Name]@row, {Intake Project Name},0))

Kelly Moore

Oops you already caught the inadvertent parenthesis. Nice catch