dragging a formula into a column which references unconsecutive rows

[mgregoir]

For example I need H1,H2, H3, etc. to return Sheet1! G160, K160, O160, S160 etc. I have tried index, but nothing seems to work.

So basically H1=G160
H2 = k160
H3 = O160

Any help is appreciated,

thank you

[Ron Coderre]

Try this regular formula, copied down:

Please Login or Register  to view this content.

EDITED TO INCLUDE THIS ALTERNATIVE:
This regular formula continuously references more columns when copied down:

Please Login or Register  to view this content.

Is that something you can work with?

[Max, Singapore]

One way
In H1: =OFFSET($G$160,,ROWS($1:1)*4-4)
Copy down
------------------------------
Success? Wave it, click the little star at the bottom left of my responses

[mgregoir]

Thanks much! That worked!

[Max, Singapore]

welcome, great to hear