Use a formula to define row number
=INDIRECT("A"&D2^2-1)
--
David Biddulph
"INeedID" wrote in message
...
I would like to define the row number in a formula using a formula.
For example A(D2^2-1) would equal the value in cell A8 when D2 is equal to
3.
Thank you.
|