Vlookup sometimes gives some errors like this. Give a 'name' to your range
and put the name in place of (Sheet5!D3:CE34). This will work if it has a
solid number to look for.

Regards,

Jaleel

"Danopnu" wrote:

This would work, but the correct value is out in the range- its just not
bringing back the value like its supposed to- what I am trying to say is that
it should not be pointing to something that would return the #N/A error- it
has a solid number to look for

"Dave F" wrote:

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)