Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to retrieve Named Range name?
Hello,
Is there a way to retrieve range name if value is in the range? For example I got this column wit names: name 1 name 2 name 3 name 4 name 5 name 6 name 7 name 8 name 9 name 10 name 11 name 12 This column has name ranges: 1st range called CA has these names: name 1 name 2 name 3 name 4 2nd range called DC has these names: name 5 name 6 name 7 name 8 name 9 And the 3rd range is called WA: name 10 name 11 name 12 Lets say in different worksheet my formula returned name1, name8 and name 11, in the same worksheet I would like to return the location or range name associated with name. Desired result: __A_______B__ name 1___CA__ name 8___DC__ name 11__WA__ I think with nested IF functions I could achieve desired result; problem is I am exceeding the limit of allowed nested functions. And I also dont want to add additional column in original data sheet were I specify the location/range name for each name. Any suggestions? Thank you, Guntars |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List Box - For Input Range can I use named range in another workbo | Excel Worksheet Functions | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) |