Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup problem | Excel Worksheet Functions | |||
Vlookup Problem | Excel Worksheet Functions | |||
Vlookup problem... | Excel Worksheet Functions | |||
VLOOKUP problem | Excel Worksheet Functions | |||
VLOOKUP problem | Excel Discussion (Misc queries) |