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