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