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
-
Try an IF/ISERROR combo.
=IF(ISERROR([Column Name]@row), "Not Good")
Answers
-
Try an IF/ISERROR combo.
=IF(ISERROR([Column Name]@row), "Not Good")
-
that works perfectly - thanks Paul :-)
-
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!