Vlookup and Values

  • Thread starter Thread starter tkirck
  • Start date Start date
T

tkirck

When using vlookup - if the column is empty, I receive a value of "0"
in some cells (I assume this is due to the type of data in the cell),
but I would rather receive a "blank" cell. How do I modify the vlookup
calculation to return a blank if the originating cell is blank?
Thanks
 
=if(vlookup()="","",vlookup())



When using vlookup - if the column is empty, I receive a value of "0"
in some cells (I assume this is due to the type of data in the cell),
but I would rather receive a "blank" cell. How do I modify the vlookup
calculation to return a blank if the originating cell is blank?
Thanks
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
Use & with two formulas 2
Vlookups not working 2
HELP!!!!!!!!! 2
Empty cell in vlookup 9
Vlookup and return sheet name also 2
VLOOKUP worksheet function returns zero for empty cells 3
Excel formula, sum the value cell and if empty cell left blank 0

Back
Top