G Gus Jul 19, 2008 #1 When I get a #N/A return from a vlookup, how can I change that to a statement like "Sorry"? Thanks in advance 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
A AltaEgo Jul 19, 2008 #3 Using If() and ISNA(): =IF(ISNA(VLOOKUP(A8,B2:C6,2,0)),"Sorry, I can't do that",LOOKUP(A8,B2:C6,2))
