OFFSET Function

[Phosphonothioic]

Hopefully I can explain this clearly...

In Sheet1, I have values in columns A1,B1,C1,D1 etc...

In Sheet2, I want to call on those values, but here's my problem:

I need Sheet2(A1) to call Sheet1(A1)...easy enough.

But then I need Sheet2(E1) to call Sheet1(B1)...

And Sheet2(I1) to call Sheet1(C1)...

and so on down the line. Sheet2 increments by 4 cells each time.

So I'm thinking I need to use OFFSET here in some capacity, but I can't get the column criteria to do what I need it to do.

I need something that I can drag across the sheet so I don't have to do every 4th column manually in Sheet2.

Hope I got that across clearly enough. Thanks in advance for your help!

 

[Juan Pablo González]

Is there anything in Sheet2!B1:D1 ?

 

[Phosphonothioic]

Yes, there will be. I can't simply delete those columns.

 

[Juan Pablo González]

Then you won't be able to drag the formula across, but you can copy it over each cell, and it'll bring the correct results:

=INDEX(Sheet1!$1:$1,INT((COLUMN(A1)-1)/4)+1)

 

[jasonb75]

Maybe

=INDIRECT("Sheet1!RC"&(COLUMN()/4)+1,0)

Copy and paste as needed.