The below would reference the array...

=INDIRECT(VLOOKUP(U51,MFFC!$A$2:$M$11,2,0))

If this post helps click Yes
---------------
Jacob Skaria


"Monty" wrote:

i have a spread sheet with array names in each cell

I have a working formula to retrieve the correct array name


The question
=VLOOKUP(U51,MFFC!$A$2:$M$11,2)

U51 is the cell for an age group (17)
the spread sheet MFFC has the age groups starting the row and the cells
contain array names.

curlup pushups run swim bike eliptical
17 curlpt17 curltl17 pupt17 putl17 runpt17 runtl17 swimpt17 swimtl17 bikept17 biketl17 elippt17 eliptl17

the problem is that once retrieved, i cannot get the function to use the
array name because it is deemed as just text and not recognized as a valid
array name.

this is the last step to automate my form and it is proving formidable. my
only other alternative is to cut and paste the formula from another matching
cell.