-IF(ISNA(YOURVLOOKUPFORMULA),0,YOURVLOOKUPFORMULA)

Vaya con Dios,
Chuck, CABGx3



"F.Rosario" wrote:

I have a VLOOKUP that returns a dollar value from another spreadsheet. If an
entry is not found, the cell value becomes #N/A, which affects the summary of
that column. I want to test for the #N/A condition and make it 0, but I
haven't figured out the syntax to compare the value of a cell to #N/A. Any
suggestions?