VLOOKUP

[Guest]

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

 

[VBA Noob]

Hi,

Vlookup will pick up a cell with a formula. The problem may be that the
table in the lookup needs to be fixed by making the range absolute

e.g $A$1:$G$8


More on Vlookup's on the attached link

http://www.mrexcel.com/tip096.shtml

VBA Noob

 

[Guest]

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.

 

[Guest]

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

 

[VBA Noob]

Why don't you post the example ??

 

[Guest]

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,