=IF(ISNA(VLOOKUP([your vlookup])),"",VLOOKUP([your vlookup]))

Dave
--
Brevity is the soul of wit.


"MLK" wrote:

Is there a way to do a vlookup but return no value at all for #NA situations.
For example on a numeric field, If there is no match, I do not want a cell
entry at all, not even a blank. I've tried doing multiple scenarios... but
no luck.

The reason is that I need to report a blank financial value in a pivot
report to identify no match was found in order to differentiate between
legitimate 0 values and/or division errors.

Any non-numeric value automatically turns into a 0 in the pivot report -
unless the cell was completely blank in the first place and not populated. f

I tried leaving the actuals #N/A error in the cell and I though this would
work because the #N/A at least appers as-is in the pivot reports, however the
totalling doesn't work in the reports.