To answer your question, probably.

If you want to suppress #N/A errors, then do the following:
=IF(ISNA(VLOOKUP([your vlookup criteria]),"",VLOOKUP([your vlookup criteria]))

This basically says, in plain English "IF the VLOOKUP returns a #N/A error,
THEN return an empty string, ELSE do the VLOOKUP"

Dave
--
Brevity is the soul of wit.


"Danopnu" wrote:

I have a working LOOKUP function in a spreadsheet referencing another page,
but when I copy it, or even retype it in the other rows, it returns the #N/A
error. The only difference that I can see is that for some of the other rows,
there are 0 amounts- could that be messing it up? This is what the working
one is:
=VLOOKUP($AK7,Sheet5!D3:CE34,80,FALSE), and this the non working in the
next row:
=VLOOKUP($AK8,Sheet5!D3:CE34,80,FALSE)