Recognizing #N/A

[nebb]

When using the vlookup worksheet function, if the value I am looking for is not found, the system returns #N/A.
Let’s say the vlookup function is in cell A1. In cell C1, I would like to put the word “yes” if A1 contains anything but #N/A and “no” if cell A1 does contain #N/A. How might I go about doing this?

[Cutter]

Try this:

=IF(ISNA(A1),"no","yes")