Display #NO MATCH as other value
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?
Help Article Resources
Check out the Formula Handbook template!