Quick way to change #N/A and #REF to 0?

[Jake_Wrestler]

I have a worksheet that has many many formulas and some come up with #N/A or #REF. I would like to convert these to a zero value. thanks!

 

[weaverk33]

However, the formula...

=IF(ISNA(VLOOKUP(...)),0,VLOOKUP(...))

...is very inefficient since the VLOOKUP is performed twice for those requests that return a value other than #N/A!

Can this be done using GetPivotTable? =GETPIVOTDATA("Qty",Pivot!$F$3,"Month",C57,"Shrt Mdl",$A$60)