When I get a #N/A return from a vlookup, how can I change that to a
statement like "Sorry"?
Thanks in advance
Gus

Try it like this:

=IF(ISNA(VLOOKUP(........)),"Sorry",VLOOKUP(...... ...))

--
Biff
Microsoft Excel MVP


"Gus" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When I get a #N/A return from a vlookup, how can I change that to a
> statement like "Sorry"?
> Thanks in advance
> Gus
>

Using If() and ISNA():

=IF(ISNA(VLOOKUP(A8,B2:C6,2,0)),"Sorry, I can't do that",LOOKUP(A8,B2:C6,2))

--
Steve

"Gus" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When I get a #N/A return from a vlookup, how can I change that to a
> statement like "Sorry"?
> Thanks in advance
> Gus
>

Thank you both.

"Gus" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When I get a #N/A return from a vlookup, how can I change that to a
> statement like "Sorry"?
> Thanks in advance
> Gus
>