Wow! Never came across that before.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"tskogstrom" wrote in message
ups.com...
Bob and Richard,
Following works with Swedish national settings, if you need to know
sometime... "," turns to "\" and , turns to ";". Of course.

={"Telecom"\"Telecom";"Public & Healthcare"\"P&H";"Industrial &
Utilities"\"Industry";"Banking & Insurance"\"B&I";"Retail &
Logistics"\"R&L";"Other"\"Others2";"Company"\"Othe rs"}

/regards
tskogstrom




Bob Phillips skrev:

Yeah, but I was concocting mine whilst you replied, so I hadn't seen it
at
that point.

I'll take mine without the tonic please.

Bob


"RichardSchollar" wrote in message
ups.com...
That's what I said! In a round about way. Point me to the gin &
tonics...


Bob Phillips wrote:

It's the order

=LOOKUP("Public & Healthcare",{"Banking &
Insurance","B&I";"Company","Others";"Industrial &
Utilities","Industry";"Other","Others2";"Public &
Healthcare","P&H";"Retail
& Logistics","R&L";"Telecom","Telecom"})

--
---