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

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

=if(isna(vlookup(...)),"",if(vlookup(...)="","",vl ookup(...))))

or

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

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

You'll have to add the =if(a220, in front of the one you need!

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

--

Dave Peterson

Try this:

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Heather C" wrote in message
...
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),"")