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
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
Try this regular formula, copied down:
EDITED TO INCLUDE THIS ALTERNATIVE:H1: =INDEX(Sheet1!$G$160:$S$160,(ROWS($1:1)-1)*4+1)
This regular formula continuously references more columns when copied down:
Is that something you can work with?H1: =INDEX(Sheet1!$160:$160,(ROWS($1:1)-1)*4+7)
Last edited by Ron Coderre; 03-22-2014 at 09:06 PM.
Thanks much! That worked!
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
welcome, great to hear
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks