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"})

--
---