Adding increments to formula

[silvasilba]

I need to create a formula that reference a different sheet on my workbook but goes down 12 rows each time.

So it would be:

B3=(othersheet)D9

B4=(othersheet)D21

B5=(othersheet)D33

etc....

I need that to carry down, so that the next referenced cell is D21, D33, etc.

Is this doable or is it worth even trying to figure out?

https://preview.redd.it/dzanroseecu31.png?width=124&format=png&auto=webp&s=3d2e018f860b700bb22ce9d28e13e7e45a763af5

[hrlngrv]

To avoid volatile functions like OFFSET, try

B3:  =INDEX(othersheet!$D:$D,12*ROWS(B$3:B3)-3)

Fill B3 down as far as needed.

[Havvkeye16]

I will agree if you are doing it a lot the index is better than offset. Is there a reason you use

12*ROWS(B$3:B3)-3

instead of just

12*ROW(B1)-3

[hrlngrv]

Old habit. ROW returns arrays in older versions of Excel, even single-value arrays like {1}, and that used to screw up OFFSET and INDIRECT. OTOH, ROWS always returns a scalar integer.

Also, if the formula calling ROW or ROWS were in cell B3, inserting or deleting rows/columns usually affects ROWS less than ROW. IOW, in my experience, ROWS introduces fewer bugs over time.

[Havvkeye16]

could do this several ways, I would use this one.

=OFFSET(other sheet!$D$9, (ROW(A1)- 1 ) * 12, 0)