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.

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" wrote in message
...
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

IF("lookupcell"="","",
VLOOKUP("lookupcell","lookuprange","returnvaluecol umn","false??"))




"Eaglered" wrote in message
...
I need Vlookup to return a blank if the appropriate cell is empty.

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

J.