Dave,

Thank you. I thought I tried that, but I guess not. If the "If" statement
is true (=""), why doesn't the vlookup display what it looked up ("")? Why
do you need to do an IF clause to display what is in the cell anyhow? Just
wondering.

Val


"Dave Peterson" wrote:

=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