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?

Best Answer

  • Sarah123
    Sarah123 ✭✭✭✭
    Answer ✓

    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")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!