VLookUp
=IF(ISNA(YourVlookupFormula),0,YourVlookupFormula)
yes, you would put your formula in twice:
the "if" statement works like this
If (COMPARISON) ,(if its TRUE do this), (if its FALSE do this)
you could do =if (your lookup = 0, "", your lookup)
|