Referencing an array name

H

Henrik

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
 
B

Bob Phillips

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)
 
H

Henrik

I can work with this. Thanks, Bob

Bob Phillips said:
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)
Click to expand...
 
Top