Problem to reference a cell or range of cells in another worksheet in the same workbook

[akalien]

Hi,

I've got a problem to reference a cell or range of cells in another worksheet in the same workbook.

In Sheet1 I've got text in cells A1:A7 and A9:A15 and in between in A8 I'm looking to get the value from Sheet2 which is B1.

Now if I copy down those 15 Iines I want to have:

Sheet1 in A23 the value from Sheet2 B2 but due to down copying formula looks at cell B16
Sheet1 in A38 the value from Sheet2 B3 but due to down copying formula looks at cell B31
Sheet1 in A53 the value from Sheet2 B4 but due to down copying formula looks at cell B46

Any idea which form the formula should have?
Many thanks in advance

 

[offthelip]

try this:
=INDEX(Sheet2!B$1:B$99,(2+(ROW()-8)/15))

 

[akalien]

Perfect solution
Many thanks