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

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.

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

Hi

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

Hope this helps.
Andy.

"jeremy nickels" wrote in message
...
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.

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

Perfect.

Thank you.

"Andy" wrote:

Hi

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

Hope this helps.
Andy.

"jeremy nickels" wrote in message
...
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.