To test for #N/A, you can use "ISNA":

=IF(ISNA(VLOOKUP(A1,Sheet2!B1:C20,2,0)),0,VLOOKUP( A1,Sheet2!B1:C20,2,0))

Laura

"F.Rosario" wrote in message
...
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?