Thread: Array as a "named range" - formula ok in cells, but error as "named range"
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
RichardSchollar RichardSchollar is offline
external usenet poster
  
Posts: 196
Default Array as a "named range" - formula ok in cells, but error as "named range"
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"})

--
---


Reply With QuoteReply With Quote