vlookup question

[Gus]

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

 

[T. Valko]

Try it like this:

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

 

[AltaEgo]

Using If() and ISNA():

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

 

[Gus]

Thank you both.