Why does my INDEX(MATCH()) column formula return #NO MATCH for some values?

dylanchaney

I have a simple formula (below) that references another sheet matching the value @row on the destination sheet. This is a column formula in the [P6Description] column.

=INDEX({Source Sheet - Description}, MATCH([P6Number]@row, {Source Sheet - Project Number}))

Why am I getting #NO MATCH for the project numbers starting with "C" but the rest of the "PRJ…" projects match source sheet descriptions perfectly?

Paul Newcome

Try specifying an exact match in the MATCH function.

=INDEX({Range}, MATCH([Column Name]@row, {Range}, 0))

Paul Newcome

Try specifying an exact match in the MATCH function.

=INDEX({Range}, MATCH([Column Name]@row, {Range}, 0))

dylanchaney

… so easy I overlooked it. But where's the fun in that?? 😂 Thank you @Paul Newcome

Paul Newcome

Happy to help. 👍️