Dragging formula that skips column

[bc2512]

Hello all,

I am trying to copy formula that skips a column from another sheet. So for example,

B2 = sheet1!C2/sheet1!B2
C2 = sheet1!E2/sheet1!D2
D2 = sheet1!G2/sheet1!F2

Is there any easy way to copy this formula to the right?

Thank you,
BC

 

[shg]

In B2,

= INDEX(Sheet1!2:2, 2*COLUMNS(Sheet1!$A2:A2) + 1) / INDEX(Sheet1!2:2, 2*COLUMNS(Sheet1!$A2:A2))

 

[bc2512]

Hi,

Thank you for the reply.

Im sorry, but when you put Sheet!2:2 ... which cell should I refer to?

Thank you.

 

[bc2512]

Hi,

Thank you for the reply.

Im sorry, but when you put Sheet!2:2 ... which cell should I refer to?

Thank you.

I figured out ... thank you so much ... it works like a wonder