 |
 |
|
|
|
07-19-2008, 02:47 AM
|
|||
|
|||
|
Re: vlookup question
Try it like this:
=IF(ISNA(VLOOKUP(........)),"Sorry",VLOOKUP(...... ...)) -- Biff Microsoft Excel MVP "Gus" <stoomfiets@ketting.co.ut> wrote in message news:u0WoShU6IHA.2060@TK2MSFTNGP02.phx.gbl... > When I get a #N/A return from a vlookup, how can I change that to a > statement like "Sorry"? > Thanks in advance > Gus > 
|
|
07-19-2008, 02:53 AM
|
|||
|
|||
|
Re: vlookup question
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" <stoomfiets@ketting.co.ut> wrote in message news:u0WoShU6IHA.2060@TK2MSFTNGP02.phx.gbl... > When I get a #N/A return from a vlookup, how can I change that to a > statement like "Sorry"? > Thanks in advance > Gus >
|
|
07-19-2008, 08:54 AM
|
|||
|
|||
|
Re: vlookup question
Thank you both.
"Gus" <stoomfiets@ketting.co.ut> wrote in message news:u0WoShU6IHA.2060@TK2MSFTNGP02.phx.gbl... > When I get a #N/A return from a vlookup, how can I change that to a > statement like "Sorry"? > Thanks in advance > Gus >
|
 |
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
