you could do it with:
=INDIRECT("A"&AL7)

But of course! I've been using that function this past week to populate
a report sheet with data stored in named ranges on another sheet, based
on user criteria in a helper column with a row-relative name...

=INDIRECT(Data!Key,ThisNdx) 'for single column data

=INDIRECT(Data!Key,ThisNdx,ColNdx) 'for multi column data

...where the target cells are in one column on the report sheet, and the
data is in single rows of named ranges that may be multi column
depending on how many 'sections' there are for reporting a specific
category of data.

This, IMO, is the simpler solution that you suggest which works better
where VBA isn't desired!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion