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?


--
nebb
------------------------------------------------------------------------
nebb's Profile: http://www.excelforum.com/member.php...fo&userid=8981
View this thread: http://www.excelforum.com/showthread...hreadid=477366