Increasing row No. by 30 from previous tab when dragging formula down

[Paul Silverwood]

https://www.dropbox.com/s/i2bstjil8pgkbha/Master Estimate.xlsx?dl=0
Please see spreadsheet I am trying to set up
The H12 cell is showing the correct result but I have had to manually pick the required cell from the Estimate tab. This is 30 rows down from the H11 cell. What formula would do this which I can drag down row H increasing the row No. from the estimate tab by 30 rows ?

 

[JustynaMK]

Hi Paul,

I suggest using INDEX function. If data that you want to extract is present in "Estimate" tab, then you can use the following function:
=INDEX(Estimate!F:F,36+30*(ROW(A1)-1),1)

INDEX will return an intersection of column F and a given row number, which will increase with each row when you drag the formula down. So the cell references will look like that:
F36, F66, F96, F126, and so on...

Does that help?

 

[Paul Silverwood]

Hi Paul,

I suggest using INDEX function. If data that you want to extract is present in "Estimate" tab, then you can use the following function:
=INDEX(Estimate!F:F,36+30*(ROW(A1)-1),1)

INDEX will return an intersection of column F and a given row number, which will increase with each row when you drag the formula down. So the cell references will look like that:
F36, F66, F96, F126, and so on...

Does that help?

Thats perfect thank you

 

[JustynaMK]

no problem! Take care.