When you look up text you look up text
=vlookup("0045",etc

--
Don Guillett
SalesAid Software

"Michael Kintner" wrote in message
...
Possible Bug???

I have three columns

1934 test1 chk1
0189 test2 chk2
0045 test3 chk3

Column A is a number formated as text to keep leading zeros. And this
data
is all preentered.

When I perform a VLOOKUP on column A to return the data from colum C I get
#N/A.

However if I reenter the exact number in column A I get the correct
answer?
Why?

Thanks in advance for any help.

Mike