Vlookup and Values
 

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

Vlookup and Values
 

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



wrote:

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

--

Dave Peterson