Display #NO MATCH as other value

Bethany Garcia

I have a vlookup that will sometimes not return a value and instead returns #NO MATCH. I'm trying to create a helper column to translate that #NO MATCH into helpful text for the end user, like "Not Found on Verizon Invoice" to indicate the row exists on our internal tracking sheet but not on our company invoice. I can't seem to figure out how to get a formula to recognize that value to display the text I want it to. How do I get a formula to recognize #NO MATCH being returned instead of a value?

Sarah123

Use the IFERROR formula along with your formula. This will tell the cell that if there is any error to show Not Found on Verizon Invoice.

=IFERROR(formula you already have, "Not Found on Verizon Invoice")

Sarah123

Use the IFERROR formula along with your formula. This will tell the cell that if there is any error to show Not Found on Verizon Invoice.

=IFERROR(formula you already have, "Not Found on Verizon Invoice")

Bethany Garcia

That worked, thank you!