The generic fix is =IF(ISERROR(YourFormula),ErrVal,YourFormula)

Using your example it would look like the following:

=IF(ISERROR(IF(A220, VLOOKUP(C22,UPC!A4:H1302,2,FALSE),"")),0,IF(A220,
VLOOKUP(C22,UPC!A4:H1302,2,FALSE),""))

Hope this helps.
--
Kevin Backmann


"Heather C" wrote:

I would like the cell to say something different then #N/A when it cannot
find the exact value. This is my current formula =IF(A220,
VLOOKUP(C22,UPC!A4:H1302,2,FALSE),"")