Need to increment columns in a formula while across

[felixg]

Sorry for the newbie question and it probably something simple or was answered before, but i would appreciate any sort of help on this one

I have an excel document with two sheets.

on first sheet i have a table from Column H to S
on the second sheet i have a table from Column E to CU

the answering that i'm looking to get in Sheet1 are located in Sheet2 starting with Column K and then every other 8th column so next one is S then AA and etc.

basically i want in Sheet1
Cell H1 to equal to =Sheet2!K1
Cell I1 to equal to =Sheet2!S1
and so on, but instead of typing it manually i want to be able to drag the formula and every increase in column in Sheet1 will increase the column by 8 in Sheet2.

hopefully the above makes sense and there is a solution to my madness.

Thank you

 

[Fluff]

Hi & welcome to MrExcel.
How about

=INDEX(Sheet2!$K$1:$CU$1,COLUMNS($H1:H1)*8-7)

 

[felixg]

Hi & welcome to MrExcel.
How about

=INDEX(Sheet2!$K$1:$CU$1,COLUMNS($H1:H1)*8-7)

wow that is amazing! thank you so much.

what if i want to bring a value from a different row then 1st? let say 21?

 

[felixg]

never mind. figure it out!

thanks

 

[Fluff]

You're welcome & thanks for the feedback.