Give me a more specific example.
--
Gary''s Student - gsnu200746


"Arun" wrote:

Yes, I think that this will work well - except that it does not seem to work
at all if the range is dynamic. I have the range defined as a formula using
the InsertNameDefine menu (it does not appear on the drop down list in the
menu bar). Do you find this to be the case also?

"Gary''s Student" wrote:

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