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