Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP Function gives wrong results
I have the following sheet:
A B C D E F 1 qwe rtz uio asd fgh jkl 2 1 2 3 4 5 6 3 4 qwe =LOOKUP(A4;$A$1:$K$2) The function in B4 should return "1", but it returns "6". The value changes if I delete some columns (e.g. if I delete columns D,E, and F, I get a correct value). When I am using just "a", "b", "c" instead names like "qwe", "rtz",... I get the correct values. What am I doing wrong? I am using XP and Excel 2003 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP Function gives wrong results
Hi,
Is this what your trying to do =HLOOKUP(A4,$A$1:F$2,2,FALSE) Mike "AndreasW" wrote: I have the following sheet: A B C D E F 1 qwe rtz uio asd fgh jkl 2 1 2 3 4 5 6 3 4 qwe =LOOKUP(A4;$A$1:$K$2) The function in B4 should return "1", but it returns "6". The value changes if I delete some columns (e.g. if I delete columns D,E, and F, I get a correct value). When I am using just "a", "b", "c" instead names like "qwe", "rtz",... I get the correct values. What am I doing wrong? I am using XP and Excel 2003 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP Function gives wrong results
I forgot to mention my version of Excel uses , and not ; so change it to ;
after the A4 Mike "Mike H" wrote: Hi, Is this what your trying to do =HLOOKUP(A4,$A$1:F$2,2,FALSE) Mike "AndreasW" wrote: I have the following sheet: A B C D E F 1 qwe rtz uio asd fgh jkl 2 1 2 3 4 5 6 3 4 qwe =LOOKUP(A4;$A$1:$K$2) The function in B4 should return "1", but it returns "6". The value changes if I delete some columns (e.g. if I delete columns D,E, and F, I get a correct value). When I am using just "a", "b", "c" instead names like "qwe", "rtz",... I get the correct values. What am I doing wrong? I am using XP and Excel 2003 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP Function gives wrong results
Yes, that's it. Thanks a lot.
"Mike H" wrote: I forgot to mention my version of Excel uses , and not ; so change it to ; after the A4 Mike "Mike H" wrote: Hi, Is this what your trying to do =HLOOKUP(A4,$A$1:F$2,2,FALSE) Mike "AndreasW" wrote: I have the following sheet: A B C D E F 1 qwe rtz uio asd fgh jkl 2 1 2 3 4 5 6 3 4 qwe =LOOKUP(A4;$A$1:$K$2) The function in B4 should return "1", but it returns "6". The value changes if I delete some columns (e.g. if I delete columns D,E, and F, I get a correct value). When I am using just "a", "b", "c" instead names like "qwe", "rtz",... I get the correct values. What am I doing wrong? I am using XP and Excel 2003 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP Function gives wrong results
Hi,
Try this =LOOKUP(A4,$A$1:$F$1,$A$2:$F$2) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "AndreasW" wrote in message ... I have the following sheet: A B C D E F 1 qwe rtz uio asd fgh jkl 2 1 2 3 4 5 6 3 4 qwe =LOOKUP(A4;$A$1:$K$2) The function in B4 should return "1", but it returns "6". The value changes if I delete some columns (e.g. if I delete columns D,E, and F, I get a correct value). When I am using just "a", "b", "c" instead names like "qwe", "rtz",... I get the correct values. What am I doing wrong? I am using XP and Excel 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrong results from MATCH function | Excel Worksheet Functions | |||
Lookup function - Wrong info when I add lines to reference spreads | Excel Discussion (Misc queries) | |||
Lookup function gives wrong values occasionally | Excel Discussion (Misc queries) | |||
Excel 2002 Lookup formula returning wrong results? | Excel Worksheet Functions | |||
lookup function bringing in wrong info | Excel Worksheet Functions |