Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting range in list of range names depending on a cell informa
I need a formula that selects in the list of range names the one related to
the information of a cell. I have the following formula Index(GERVar, MATCH(Value A,Lookup ArrayA,0, MATCH(Value B, Lookup ArrayB,0)) And when I have "Germany" in a certain cell, the formula will look for the right value within the range "GERVar" previously created. If now I have "France" in a certain cell, the array will not be GERVar anymore but FRAVar in the Index formula as follows: Index(FRAVar, MATCH(Value A,Lookup ArrayA,0, MATCH(Value B, Lookup ArrayB,0)) I know that this is maybe not as easy as that, maybe not feasable with such the formula I wrote but the idea is there. Please could you help me? Anne de Courreges |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamicly change spreadsheet tab names depending on cell value | Excel Discussion (Misc queries) | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Lookup cell value using list of worksheet names | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |