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