I need Vlookup to return a blank

[Guest]

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

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

J.

 

[Guest]

This will work -

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

 

[Chip Pearson]

Try something like

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


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

 

[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()))

 

[PC]

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