I need Vlookup to return a blank

I need Vlookup to return a blank if the appropriate cell is empty.

Thank you so much . . . .Y'all have been extremely helpful!!

J.

IF("lookupcell"="","",
VLOOKUP("lookupcell","lookuprange","returnvaluecolumn","false??"))




"Eaglered" <Eaglered@discussions.microsoft.com> wrote in message
news:CE83289E-F0CB-4684-B836-FFE6D3E2DC82@microsoft.com...
> I need Vlookup to return a blank if the appropriate cell is empty.
>
> Thank you so much . . . .Y'all have been extremely helpful!!
>
> J.

This will work -

=if(vlookup(,,,)=[whatever the cause of the blank is],"",vlookup(,,,))

"Eaglered" wrote:

> I need Vlookup to return a blank if the appropriate cell is empty.
>
> Thank you so much . . . .Y'all have been extremely helpful!!
>
> J.

Try something like

=IF(ISERROR(VLOOKUP(...)),"",VLOOKUP(...))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Eaglered" <Eaglered@discussions.microsoft.com> wrote in message
news:CE83289E-F0CB-4684-B836-FFE6D3E2DC82@microsoft.com...
>I need Vlookup to return a blank if the appropriate cell is
>empty.
>
> Thank you so much . . . .Y'all have been extremely helpful!!
>
> J.

Instead of returning a 0?

=if(vlookup()="","",vlookup())

And to get rid of the #n/a's:

=if(iserror(vlookup()),"missing",if(vlookup()="","",vlookup()))



Eaglered wrote:
>
> I need Vlookup to return a blank if the appropriate cell is empty.
>
> Thank you so much . . . .Y'all have been extremely helpful!!
>
> J.

--

Dave Peterson