View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default VLookup Null values

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



Babylooch wrote:

I am looking up values in a Pivot Table. If the value is null, the formula
is displaying zero instead of null. Is there a way to display null when null
and zero when the value is zero?


--

Dave Peterson