Two other things to look out for:

if you are looking up numbers, ensure that you really do have numbers
and not text values that look like numbers (i.e. may appear that the
value is in the table, but if one is text then a match will not be
found).

if you are looking up text values, ensure that you do not have leading
or trailing spaces (which are not visible, so the entry may "look" the
same).

Hope this helps.

Pete

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)