Detecting #No Match

RayB

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 ?

Paul Newcome

Try an IF/ISERROR combo.

=IF(ISERROR([Column Name]@row), "Not Good")

Paul Newcome

Try an IF/ISERROR combo.

=IF(ISERROR([Column Name]@row), "Not Good")

RayB

that works perfectly - thanks Paul :-)

Paul Newcome

Happy to help. 👍️