How can I have a false Vlookup give a blank instead of #N/A?

's Computer Specifications

I'm looking up values in a column using the VLOOKUP with the FALSE included
so that if the lookup item isn't present, I purposely get a "#N/A". Can I
nest an "IF" statement so that if the vlookup returns a "#N/A", I want it to
appear blank instead of getting the "#N/A"? Thanks.

's Computer Specifications

=IF(ISNA(vlookup_formula),"",vlookup_formula)

--

Regards,

Peo Sjoblom

"TQCON" <(E-Mail Removed)> wrote in message
news:16556C9E-DD19-4801-8736-(E-Mail Removed)...
> I'm looking up values in a column using the VLOOKUP with the FALSE
> included
> so that if the lookup item isn't present, I purposely get a "#N/A". Can I
> nest an "IF" statement so that if the vlookup returns a "#N/A", I want it
> to
> appear blank instead of getting the "#N/A"? Thanks.

's Computer Specifications

Thanks, Peo. That solves the problem. I also then noticed that this
question is a common one that has been solved many times.

"Peo Sjoblom" wrote:

> =IF(ISNA(vlookup_formula),"",vlookup_formula)
>
>
> --
>
>
> Regards,
>
>
> Peo Sjoblom
>
>
>
> "TQCON" <(E-Mail Removed)> wrote in message
> news:16556C9E-DD19-4801-8736-(E-Mail Removed)...
> > I'm looking up values in a column using the VLOOKUP with the FALSE
> > included
> > so that if the lookup item isn't present, I purposely get a "#N/A". Can I
> > nest an "IF" statement so that if the vlookup returns a "#N/A", I want it
> > to
> > appear blank instead of getting the "#N/A"? Thanks.
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Blank entry in an IF statement returns FALSE. I want it to be blank	wasted wanderer	Microsoft Excel Discussion	2	5th Apr 2008 08:17 PM
Macro code to test for blank row and insert blank row if false	=?Utf-8?B?TWF0dGll?=	Microsoft Excel Programming	2	29th Mar 2006 01:19 AM
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE)	=?Utf-8?B?TWlrZVItT3o=?=	Microsoft Excel New Users	1	22nd Mar 2006 09:01 AM
IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM?	=?Utf-8?B?YmNoaWx0?=	Microsoft Excel Worksheet Functions	6	20th Jan 2006 09:21 AM
Can I add blank space instead of 'FALSE' in VLookup?	=?Utf-8?B?c21pdGhlcnMyMDAy?=	Microsoft Excel Worksheet Functions	7	22nd Apr 2005 09:33 AM