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

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?