VLOOKUP Problem

[Michael Kintner]

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

 

[Don Guillett]

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

 

[Tom Ogilvy]

"1934" <> 1934

=vlookup(Text(A1,"0000"),Range,2,False)

 

[Michael Kintner]

Thank you!!

"1934" <> 1934

=vlookup(Text(A1,"0000"),Range,2,False)