View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default 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"})

--
---