Here is my question (BTW, I am using Excel 2003):

I have a table of values, and I have given each column in the table a name
(created with Insert|Name|Define). For instance, these names may be
something like

Price | Weight | Volume | Age | etc., beginning at address A10
100 | 3 | 10 | 6 |
20 | 5 | 7 | 1 |


Now, I want to create a new column with values derived from the values in
this table. The difficulty is that I would like to have the formula (for
instance, =Weight/Volume) in one place only (say, cell B1), in such as way
that I can change the formula in B1 and cause the change to propagate to the
entire new column of my table.

In essence, what I would like is a function that says: evaluate the formula
in $B$1 as if that formula had been written in the current cell. It's
something like =offset($b$1,0,0) or =indirect("$B$1"), but for formulas
involving Names.

Any suggestions would be greatly appreciated.

Thanks,

Gabriel