Use a formula to define row number
 

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.

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.

Use a formula to define row number
 

Thank you for your help!

"David Biddulph" wrote:

=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.