Referencing an array name
 

I have an index formula where the array referenced varies, depending on other
conditions. For the sake of illustration, assume that the formula is
=INDEX(ARRAYx, row, column) and that ARRAYx can be any of ARRAY1-ARRAYn.

How do I build that into a formula? I've been playing with LOOPKUP formulae
with the name of the arrays being referred to but that does not seem to work.

Thanks
Henrik

Referencing an array name
 

Is this what you mean

=INDEX(INDIRECT(L1),row,column)

where L1 would hold say A1:A10

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"Henrik" wrote in message
...
I have an index formula where the array referenced varies, depending on
other
conditions. For the sake of illustration, assume that the formula is
=INDEX(ARRAYx, row, column) and that ARRAYx can be any of ARRAY1-ARRAYn.

How do I build that into a formula? I've been playing with LOOPKUP
formulae
with the name of the arrays being referred to but that does not seem to
work.

Thanks
Henrik

Referencing an array name
 

I can work with this. Thanks, Bob

"Bob Phillips" wrote:

Is this what you mean

=INDEX(INDIRECT(L1),row,column)

where L1 would hold say A1:A10

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"Henrik" wrote in message
...
I have an index formula where the array referenced varies, depending on
other
conditions. For the sake of illustration, assume that the formula is
=INDEX(ARRAYx, row, column) and that ARRAYx can be any of ARRAY1-ARRAYn.

How do I build that into a formula? I've been playing with LOOPKUP
formulae
with the name of the arrays being referred to but that does not seem to
work.

Thanks
Henrik