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

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


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=569104

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)),"",VLOOKU P(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.

"steph44haf" wrote:

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

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

"steph44haf" wrote:

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

Why don't you post the example ??


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=569104

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,



"VBA Noob" wrote:


Why don't you post the example ??


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=569104

Steph,
I've had something like that happen to me and what I did was use Value(cell)
to make sure it was a number. (They looked like numbers to me but apparenly
Excel thought some of them were text...) However, you appear to have both
numbers and letters working here so I don't know how well that would work for
you.

I would check and make sure that whatever the lookup value type is (number,
text) is the same as the type on the lookup table.

Hope this helps to point you where to look,
Alicia



"steph44haf" wrote:

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,



"VBA Noob" wrote:


Why don't you post the example ??


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=569104