Skipping rows

[aliabdullah20]

I have a 30 year amortization table on one sheet. On a master sheet, I want the ending principle balance for each year. For example beg balance for 2015 is in cell F15 the ending balance for 2015 in cell F27 and then ending balance for 2016 is 12 rows later, in cell F39.

Hence on the master sheet, I want to pull in F15 and every value 12 rows later. Any suggestions ?

[Jonmo1]

Try

=INDEX('amortization sheet'!F:F,(ROWS(A$1:A1)-1)*12+15)

Don't change ROWS(A$1:A1), it has nothing to do with your data.
*12 is the interval - every 12 rows
+15 is the beginning Row #.

[Glenn Kennedy]

=OFFSET('Amortization sheet'!$F$15,(ROWS($1:1)-1)*12,,)

should do it... Drag down.

[Jonmo1]

Note, it was unclear in your post which sheet was which.
You only named 'Master'
But is Master the sheet where you want to put these formulas, or the sheet that contains the values you want to retrieve?

My formula assumed Master is where the formulas go, and 'amortization sheet' is the sheet that contains the values you want to retrieve.

[Glenn Kennedy]

Jonmo - I think your guess about the sheet name was closer than mine (I edited mine later to match yours). In any event; both formulas will do the job.

[aliabdullah20]

Master sheet is where I am entering the formula. Sorry about the confusion

[Glenn Kennedy]

yea - but what's the name of the sheet you're pulling it FROM

[aliabdullah20]

That tab is called "amortization schedule"

[Jonmo1]

That tab is called "amortization schedule"

Great, so just take either formula posted, and change the sheetname accordingly.