Using the active cell content

V

Vincent DAVID

I'd like to update result of formula in any cell,
according to the content of the active cell.
How should I write the formula ?

ex in A1:A10 are the years from 2001 to 2010

in A21, i'd like to see the content of the cell I click on
(within the A1:A10 range). What should I write as a
formula in A21 ?
Thanks
 
J

Jim Rech

You could use a formula like this but it requires a calc to make it update,
as all formulas do.

=INDIRECT(CELL("address"))

--
Jim Rech
Excel MVP
| I'd like to update result of formula in any cell,
| according to the content of the active cell.
| How should I write the formula ?
|
| ex in A1:A10 are the years from 2001 to 2010
|
| in A21, i'd like to see the content of the cell I click on
| (within the A1:A10 range). What should I write as a
| formula in A21 ?
| Thanks
 
Top