software

I would like to be able to use a cell reference, in a formula, that points to
a cell that contains a Range Name. I hope I've stated that clearly. Just
in case, I'll give my example --

I have a table in which I've created many lookups, all of which look to a
range named Term1. I want to be able to copy my table, but I need to be
able to change each copy to look at Term2, Term3, Term4, etc.... So, I
thought I would just use a cell reference in my lookup formulas, and point to
a cell that contains whichever range I want to use. This way, I don't have
to change the formulas in my table. I know I can do a search and replace,
but I didn't want to have to do that.

So.. Is there a way to use a cell reference in a formula, where that cell
reference contains a range name?

Thanks, in advance.
Use INDIRECT():
Let's say we put 1,2,3,4,5,6,7,8,9 in cells A1 thru C3.
Let's say we assign the block A1:C3 the Name topleft.

Enter topleft in F1 and in F2 enter:

=SUM(INDIRECT(F1)) to display 45--
Gary's Studentquot;SCSCquot; wrote:

gt; I would like to be able to use a cell reference, in a formula, that points to
gt; a cell that contains a Range Name. I hope I've stated that clearly. Just
gt; in case, I'll give my example --
gt;
gt; I have a table in which I've created many lookups, all of which look to a
gt; range named Term1. I want to be able to copy my table, but I need to be
gt; able to change each copy to look at Term2, Term3, Term4, etc.... So, I
gt; thought I would just use a cell reference in my lookup formulas, and point to
gt; a cell that contains whichever range I want to use. This way, I don't have
gt; to change the formulas in my table. I know I can do a search and replace,
gt; but I didn't want to have to do that.
gt;
gt; So.. Is there a way to use a cell reference in a formula, where that cell
gt; reference contains a range name?
gt;
gt; Thanks, in advance.
gt;
gt;

THANKS! That works perfectly!quot;Gary''s Studentquot; wrote:

gt; Use INDIRECT():
gt; Let's say we put 1,2,3,4,5,6,7,8,9 in cells A1 thru C3.
gt; Let's say we assign the block A1:C3 the Name topleft.
gt;
gt; Enter topleft in F1 and in F2 enter:
gt;
gt; =SUM(INDIRECT(F1)) to display 45
gt;
gt;
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;SCSCquot; wrote:
gt;
gt; gt; I would like to be able to use a cell reference, in a formula, that points to
gt; gt; a cell that contains a Range Name. I hope I've stated that clearly. Just
gt; gt; in case, I'll give my example --
gt; gt;
gt; gt; I have a table in which I've created many lookups, all of which look to a
gt; gt; range named Term1. I want to be able to copy my table, but I need to be
gt; gt; able to change each copy to look at Term2, Term3, Term4, etc.... So, I
gt; gt; thought I would just use a cell reference in my lookup formulas, and point to
gt; gt; a cell that contains whichever range I want to use. This way, I don't have
gt; gt; to change the formulas in my table. I know I can do a search and replace,
gt; gt; but I didn't want to have to do that.
gt; gt;
gt; gt; So.. Is there a way to use a cell reference in a formula, where that cell
gt; gt; reference contains a range name?
gt; gt;
gt; gt; Thanks, in advance.
gt; gt;
gt; gt;