Detecting #No Match


Using VLOOKUP to check if a name entered via a form appears in a different sheet. If the name does appear then it pulls values from that other sheet. This all works fine. What I would like to do is build some processes when the name does not match - this appears as #No Match in the related VLOOKUP cells. I want to use that to set a value in a helper column (to trigger other processes) but I can't work out how to test for it. Any suggestions I can try ?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!