Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup order
When you lookup text in a column does it have to be in alphabetical order?
When I type in the following it works as I want it to. =Lookup(P2,{"Advanced","Regular"."Title"},{"A","R" ,"X"}) If I use: =Lookup(P2,{"Title","Advanced","Regular"},{"X","A" ,"R"}) title doesn't list X, etc. How does the order of what you enter in the first set of brackets correspond or link to the letters or text in the second set? Thanks for helping a rookie. nordic |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup order
The Excel help file says the lookup values must be place in ascending order. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Nordic" wrote in message When you lookup text in a column does it have to be in alphabetical order? When I type in the following it works as I want it to. =Lookup(P2,{"Advanced","Regular"."Title"},{"A","R" ,"X"}) If I use: =Lookup(P2,{"Title","Advanced","Regular"},{"X","A" ,"R"}) title doesn't list X, etc. How does the order of what you enter in the first set of brackets correspond or link to the letters or text in the second set? Thanks for helping a rookie. nordic |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup order
Yes.
The original formula I posted to your other thread works only when the items between the first set of { } are in alphabetical order as you have found by experimenting. Gord Dibben MS Excel MVP On Sat, 3 May 2008 18:44:00 -0700, Nordic wrote: When you lookup text in a column does it have to be in alphabetical order? When I type in the following it works as I want it to. =Lookup(P2,{"Advanced","Regular"."Title"},{"A","R ","X"}) If I use: =Lookup(P2,{"Title","Advanced","Regular"},{"X","A" ,"R"}) title doesn't list X, etc. How does the order of what you enter in the first set of brackets correspond or link to the letters or text in the second set? Thanks for helping a rookie. nordic |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup needed for names in varying order | Excel Worksheet Functions | |||
How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
How do I lookup a value in a array that is not in ascending order | Excel Worksheet Functions | |||
Lookup values in a column and display them in order with no gaps | Excel Worksheet Functions | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |