VLOOKUP Problem
 

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

VLOOKUP Problem
 

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

VLOOKUP Problem
 

"1934" < 1934

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

--
Regards,
Tom Ogilvy

"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

VLOOKUP Problem
 

Thank you!!


"Tom Ogilvy" wrote in message
...
"1934" < 1934

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

--
Regards,
Tom Ogilvy

"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