Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Any ideas why a reference that works will in 2003 has problems in
I am using a reference shown here =LOOKUP("X",Y11:Y15,X11:X15) to find a
number in a column to the right of an €œX€ 0 X 1 2 3 4 In this example the x is next to the number 1, and should return that value- however in 2007 excel it seems to show the value 4 when the x is next to the 2 ( or at least some other number). Thoughts ideas? george |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Any ideas why a reference that works will in 2003 has problems in
Works the same in both versions for me. Are you sure the "x" is the only
entry in the range? Might there be formula blanks? Use this instead: =INDEX(X11:X15,MATCH("x",Y11:Y15,0)) -- Biff Microsoft Excel MVP "george" wrote in message ... I am using a reference shown here =LOOKUP("X",Y11:Y15,X11:X15) to find a number in a column to the right of an "X" 0 X 1 2 3 4 In this example the x is next to the number 1, and should return that value- however in 2007 excel it seems to show the value 4 when the x is next to the 2 ( or at least some other number). Thoughts ideas? george |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Any ideas why a reference that works will in 2003 has problems in
On Sat, 19 Jul 2008 10:03:01 -0700, george
wrote: I am using a reference shown here =LOOKUP("X",Y11:Y15,X11:X15) to find a number in a column to the right of an “X” 0 X 1 2 3 4 In this example the x is next to the number 1, and should return that value- however in 2007 excel it seems to show the value 4 when the x is next to the 2 ( or at least some other number). Thoughts ideas? george Your formula seems to work fine here. Perhaps some issue with your data? --ron |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Any ideas why a reference that works will in 2003 has problems in
Hey thanks guys-
Ill give the index a try€¦. Out of curiosity why does the index work better than a €œlookup€ ? Cheers george "george" wrote: I am using a reference shown here =LOOKUP("X",Y11:Y15,X11:X15) to find a number in a column to the right of an €œX€ 0 X 1 2 3 4 In this example the x is next to the number 1, and should return that value- however in 2007 excel it seems to show the value 4 when the x is next to the 2 ( or at least some other number). Thoughts ideas? george |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Any ideas why a reference that works will in 2003 has problems in
The LOOKUP function works just fine, but under strict constraints. The
lookup_vector *must* be sorted in ascending order otherwise you'll get incorrect results. The combination of INDEX/MATCH gives more leeway in that the lookup_array can be either sorted or unsorted. -- Biff Microsoft Excel MVP "george" wrote in message ... Hey thanks guys- Ill give the index a try.. Out of curiosity why does the index work better than a "lookup" ? Cheers george "george" wrote: I am using a reference shown here =LOOKUP("X",Y11:Y15,X11:X15) to find a number in a column to the right of an "X" 0 X 1 2 3 4 In this example the x is next to the number 1, and should return that value- however in 2007 excel it seems to show the value 4 when the x is next to the 2 ( or at least some other number). Thoughts ideas? george |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting a cell reference when a value is less than 0 in Excel Works | Excel Worksheet Functions | |||
Spreadsheet SUM(C:C) or indeed any SUM no longer works Excel 2003 | Excel Worksheet Functions | |||
Index match formula works in for one worksheet reference but not another | Excel Worksheet Functions | |||
how do I convert a Works spreadsheet to Excel 2003 | Excel Discussion (Misc queries) | |||
Works 4.0(wks) needs to be converted to Excel 2003 | Excel Discussion (Misc queries) |