Drag down formula in row an increment value by more than 1

[jeffdlinn]

I think I need the ROW function here, but I can't seem to get it to work.

In sheet 2 I reference values in Sheet 1 and when I drag down the formula it performs as expected.

Row 1 =Sheet1!A1
Row 2 =Sheet1!A2
Row 3 =Sheet1!A3
Row 4 =Sheet1!A4
Row 5 =Sheet1!A5
Row 6 =Sheet1!A6
When I drag the formula down I want it to increment by different values maybe 2, 5, 7,50. In this case, I need it to increment by 12. So when I drag the formula down it should be as follows.
Row 1 =Sheet1!A1
Row 2 =Sheet1!A12
Row 3 =Sheet1!A24
Row 4 =Sheet1!A36
Row 5 =Sheet1!A48
Row 6 =Sheet1!A60

Seems to be a simple request, but I can't figure out how to do this.

 

[BigBeachBananas]

Row 1 =Sheet1!A1
Row 2 =Sheet1!A12
Row 3 =Sheet1!A24
Row 4 =Sheet1!A36
Row 5 =Sheet1!A48
Row 6 =Sheet1!A60

If you're increment by 12 should it be 1,13,25, 37, etc....?

 

[StephenCrump]

In Sheet2!A1, you could have: =INDEX(Sheet1!A:A,ROWS(A$1:A1)*12-11), and copy down

Or with Excel 365, you could do it in the one formula:

=INDEX(Sheet1!A:A,SEQUENCE(6,,1,12))

Edit: Yes, I assumed: 1,13,25, 37, etc....? Adjust the formula as appropriate

 

[jeffdlinn]

Row 1 =Sheet1!A1
Row 2 =Sheet1!A12
Row 3 =Sheet1!A24
Row 4 =Sheet1!A36
Row 5 =Sheet1!A48
Row 6 =Sheet1!A60

If you're increment by 12 should it be 1,13,25, 37, etc....?

Correct, I should have said 11

 

[BigBeachBananas]

Assuming this is what you want... 1,12,24,36, ...
Keep Row 1 = Sheet1!A1
Paste this in Row 2 & drag down.

=OFFSET(Sheet1!$A$1,12*ROW(A2)-13,0)

 

[jeffdlinn]

In Sheet2!A1, you could have: =INDEX(Sheet1!A:A,ROWS(A$1:A1)*12-11), and copy down

Or with Excel 365, you could do it in the one formula:

=INDEX(Sheet1!A:A,SEQUENCE(6,,1,12))

Edit: Yes, I assumed: 1,13,25, 37, etc....? Adjust the formula as appropriate

MREXCEL1

Financial Model PURCHASE,REFINANCE,CASH FLOW,MONTHLY,YEARLY BRRRRFECT,$67,230,After Repair Value,$290,000,Gross Rent,$2,900,$34,800 Purchase Price,$95,000,ARLTV,75.00%,Vacancy,-,$145,$1,740 Rehab Costs,+,$150,270,Operating Income,=,$2,755,$33,060 Amount Financed,-,$198,669,Refinance Loan Amount...

docs.google.com

So close. I tried the first formula. See the spreadsheet above and see the Yearly tab Column O (Cell O12). The numbers I am expecting to see are in Column P

 

[StephenCrump]

You have O12: =INDEX(Amortization!F6:F642,ROWS(F$1:F1)*12-11)

Try O12: =INDEX(Amortization!F$17:F$642,ROWS(F$12:F12)*12-11)