formula help

[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),"")

 

[Kevin B]

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.

 

[Dave Peterson]

=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!

 

[RagDyer]

Try this:

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