I need Vlookup to return a blank

E

Eaglered

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

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

J.
 
T

Tony P.

This will work -

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

Chip Pearson

Try something like

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


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

Dave Peterson

Instead of returning a 0?

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

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

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

PC

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