Lookup order

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nordic - 04 May 2008 02:44 GMT

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 to this Message

Jim Cone - 04 May 2008 02:57 GMT

The Excel help file says the lookup values must be place in ascending order.

Signature

Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"Nordic" <Nordic@discussions.microsoft.com>
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

Reply to this Message

Gord Dibben - 04 May 2008 17:53 GMT

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

>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.
[quoted text clipped - 8 lines]
>Thanks for helping a rookie.
>nordic

Reply to this Message