formula help

  • Thread starter Thread starter Heather C
  • Start date Start date
H

Heather C

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(A22>0,
VLOOKUP(C22,UPC!A4:H1302,2,FALSE),"")
 
The generic fix is =IF(ISERROR(YourFormula),ErrVal,YourFormula)

Using your example it would look like the following:

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

Hope this helps.
 
=if(isna(vlookup(...)),"",if(vlookup(...)="","",vlookup(...))))

or

=if(iserror(1/len(vlookup(...)),"",vlookup(...))

And xl2007 has added an =iferror(), too.

You'll have to add the =if(a22>0, in front of the one you need!
 
Try this:

=IF(OR(A22<=0,ISNA(MATCH(C22,UPC!A4:A1302,0))),"",VLOOKUP(C22,UPC!A4:H1302,2,0))
 
Back
Top