Return a text string when the result of VLOOKUP formula is #N/A

J

jeremy nickels

Is there any way to have the result of a VLOOKUP formula be the text string
"NO" instead of #N/A when it doesn't find a match?

I'm playing around with an IF statement and the ERROR.TYPE function, but I'm
not quite getting it.
 
G

Guest

Hi

One approach:
=IF(ISERROR(VLOOKUP______),"ERROR",VLOOKUP_______)

Hope this helps.
Andy.
 
Top