Indirect formula adjustment to previous cell

[laptopbob]

I have the following:

P18 = 15

P21 = D16
P22 = INDIRECT("D"&16+$P$18)
P23 =

I would like P23 to get the value 15 ekstra rows further down from the value in P22. So it could be INDIRECT("D"&16+2*$P$18) or something similar and possible to copy the formula further down (P24, P25 etc) so it would be 3*, 4*, 5* etc.
It could probably also change the "D"&16 to be dependent on the previous cell.
I can definitely be done differently as well. The output is what is important and not the formula.

 

[pgc01]

Hi

Try in P21:

P21: =INDEX(D:D,16+(ROWS($P$21:P21)-1)*$P$18)


Copy down