|VLOOKUP will return a #N/A error when the lookup_value is not found. Therefore, we can combine the IF and ISNA functions to determine if the value was found or not.|
This will return No if the value is not found, Yes if it is:
If you want to return No when the value isn't found but return an actual value when it is, then this should work:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03