Array as a "named range" - formula ok in cells, but error as "named range"
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"})
--
---
|