| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Array as a "named range" - formula ok in cells, but error as "named range"
I want to have array formula as a named range, but Excel doesn't accept
this formula. Maybe it is the "&" sign, or? How should I write? I have Swedish signs, therefore use ";" instead of "," etc, I guess. ={"Telecom";"Public & Healthcare";"Industrial & Utilities";"Banking & Insurance";"Retail & Logistics";"Other";"Company"};{"Telecom";"P&H";"In dustry";"B&I";"R&L";"Others";"Others"} THIS worksheet formula is accepted into an ordinary cell.. I recieve "Others" in the cell: =LOOKUP("Company";{"Telecom";"Public & Healthcare";"Industrial & Utilities";"Banking & Insurance";"Retail & Logistics";"Other";"Company"};{"Telecom";"P&H";"In dustry";"B&I";"R&L";"Others";"Others"}) So - any idea how it should be as a named range formula? Happy to all suggestions, Tskogstrom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How can I create an array formula for non-sequential cells | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Threaded Mode
