Selecting range in list of range names depending on a cell informa
E1 contains name of range e.g GERVar, FRANVar ....
=INDEX(INDIRECT(E1),MATCH(E2,$A$2:$A$4,0),MATCH(E3 ,$B$1:$D$1,0))
HTH
"Courreges" wrote:
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
|