define names in excel

[Guest]

Is there a way to build a formula in a cell that runs a define name where the
name to be run is found in another cell.

I have a master tbale which tracks cell formats for a 200+ column worksheet.
When I add new cells or make some changes I need to change in all other cells
as well.
What I would like to do is create a generic formula in all cells that is the
same ie =RunDefineName, this would be in all 200 columns by 5 rows.
In the function I will refer to the master table (on a seperate sheet) which
for this example has 5 rows.
R1 would use defile name CALC_wk1 (this is the name you would see in the
cell value)
R2 would use defile name CALC_wk2
R3 would use defile name CALC_wk3
R4 would use defile name CALC_wk4
R5 would use defile name Total

Now when =RunDefineName runs for row1 col1 it would get the definie name
CALC_wk2 and run it as if I build the cell looking like =CALC_wk2.

The biggest reason for this is I move a lot of the rows around and doing
this would make it necessary to only move the MASTER table around.

Thanks

 

[Guest]

Not sure that it would solve all your questions, but there is a function
called CHOOSE which depending on the value of the first argument, returns the
nth + 1 argument of the function. As each argument can be a formula, this may
do the trick.