View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] tkirck@avaya.com is offline
external usenet poster
 
Posts: 1
Default 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