This is an excellent question!

Say in B2 thru D4 we have:

4 6 8
6 9 12
8 12 16

and we assign this block of cells the Name:
cars

You will find
=INDEX(B2:D4,1,1)
=INDEX(cars,1,1)
both work.

if A1 contains the text:
B2:D4
=INDEX(INDIRECT(A1),1,1) will also work

If A2 contains the text:
cars
=INDEX(INDIRECT(A2),1,1) will also work

The question is excellent to me because it revealed that I can index any of
a set of tables simply by storing the table name in a reference cell.
--
Gary''s Student - gsnu200746


"Arun" wrote:

Is it true that you cannot use the INDIRECT function to call a dynamic range
name from another cell? I have a dynamic range named Cars. Cell A1 has this
text in it. For some reason this formula is not working:

=Index(Indirect(A1),1,1)
although this works...
=Index(Cars,1,1)

If I can't do this because Cars is a dynamic range (defined with a formula
using Insert-Name) is there any work around?
-Arun