Microsoft Office Forums


Reply
Thread Tools Display Modes

vlookup question

 
 
Gus
Guest
Posts: n/a

 
      07-19-2008, 02:36 AM
When I get a #N/A return from a vlookup, how can I change that to a
statement like "Sorry"?
Thanks in advance
Gus


 
Reply With Quote
 
 
 
 
T. Valko
Guest
Posts: n/a

 
      07-19-2008, 02:47 AM
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
>



 
Reply With Quote
 
AltaEgo
Guest
Posts: n/a

 
      07-19-2008, 02:53 AM
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
>

 
Reply With Quote
 
Gus
Guest
Posts: n/a

 
      07-19-2008, 08:54 AM
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
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup question ruchie Excel Newsgroup 12 06-12-2007 11:54 AM
KBV- vlookup question KBV Excel Newsgroup 3 07-15-2006 02:57 PM
Re: vlookup question Bob Phillips Excel Newsgroup 0 12-17-2005 10:18 PM
Vlookup question Buckwheat Excel Newsgroup 2 12-18-2003 05:03 AM
vlookup question. IowaBuckMaster Excel Newsgroup 5 11-26-2003 12:17 AM



All times are GMT. The time now is 02:09 PM.