Formula to reference consecutive data & skip lines

[kydaki]

I need some help, either to figure out why the copy/paste isn't working or a formula to do this.

I need to reference consecutive data is Sheet2 to Sheet1 but skip a row in Sheet1. Like so:

in Sheet1

A10=Sheet2!A1
A11=
A12=Sheet2!A2
A13=
A14=Sheet2!A3

If I try to copy this down in Sheet1 A16 I get Sheet2!A7 NOT Sheet2!A4??

I have seen some OFFSET and INDEX formulas, but they all are for consecutive rows in 'Sheet1' skipping rows in 'Sheet2', I have not been able to modify any to achieve my goal.

Thanks in advance for any help?

 

[Andrew Poulsom]

Try this formula in A10:

=INDEX(Sheet2!A:A,((ROW(A1)-ROW(A$1)+2)/2))

 

[kydaki]

Works beautifully! Thank you so very much for your quick response!!