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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Same forumula returns both 0 & N/A 2
Look up if a value from an array "A" is in either array "B" or "C" 8
Searching the formula (not the value) for a text string 1
VLOOKUP source values are a formula result. Getting #N/A 7
Multiple VLOOKUP in an IF statement 2
Lookup functions always return n/a ??? 3
trouble with (complicated) vlookup searching another workbook 2
VLOOKUP 3

Top