Can I change the result of a formula to be blank instead of "#NO MATCH"?

Judith Campf

I have a formula that is working as expected - pulling names when it finds them in another sheet - and when the name is not there, the result is "#NO MATCH". I understand the "#NO MATCH" response, but I'm wondering if there is a way for the result to show as blank rather than the words "#NO MATCH". Below is the formula I am using:

=INDEX({23/24 Teacher Talk Attendance Range 1}, MATCH([Teacher Name]@row, {23/24 Teacher Talk Attendance Range 1}, 0))

Paul Newcome

You would use the same syntax that I have above. Just copy/paste your original formula (excluding the initial "=" symbol that indicates the start of a formula) into where I have "original_formula".

Paul Newcome

Yes. You would wrap the whole thing in an IFERROR statement.

=IFERROR(original_formula, "")

Judith Campf

Where does the error part go in the full formula? Can you type the full formula including the error part here?

Thank you, so much, Paul!

Paul Newcome

You would use the same syntax that I have above. Just copy/paste your original formula (excluding the initial "=" symbol that indicates the start of a formula) into where I have "original_formula".