VLOOKUP

S

steph44haf

I am not getting a vaule (getting #N/A) on some of my look ups. I am
wondering if it is because I have a formula in the cell instead of a value.
Can I have a formula in my lookup field?

Thanks,

Steph
 
K

kassie

A #N/A error occurs when the value you use as criteria is not found in the
lookuptable. If you say =VLOOKUP(A2,$G$1:$L$310,4,FALSE), and A2 contains
the number 1234, but there is no number 1234 in G!:G310, the formula will
retun #N/A
if you say =
IF(ISNA(VLOOKUP(A2,$G$1:$L$310,4,FALSE)),"",VLOOKUP(A2,$G$1:$L$310,4,FALSE),
you will not get the #N/A result. Instead you will get a blank cell. You
can of course change the "" to anything else.
 
S

steph44haf

Unfortunately your responses were not helpful, but thank you.

We do have the absolute range for the lookup table. If we put the formula
in to get let's say 10742 it doesn't work, but if we type in 10742 the
VLOOKUP works. So I think there is an issue here using a formula. (If the
formula says G9124 it works.)

Can anyone else comment?

Thanks,

Stephanie
 
S

steph44haf

Column A =IF('PM & PDA Use-PO Data Entry'!B3=0," ",'PM & PDA Use-PO Data
Entry'!B3)
Column B =VLOOKUP(A1,Sheet2!$A$1:$B$17000,2,FALSE)

If Column A = G6354, Column B gives correct description ex "Gloves"
If Column A = 26354, Column B can't find match and gives "#N/A"
If we type in 26354 (instead of formula) in Column A, Column B gives correct
desctiption ex "Hats"

Thanks,
 
Top