Newbie: Help with OFFSET function

[CF]

On Sheet1 I and Row106 I have 50+ columns of calculation results that I want
copied to Sheet2, Column 4 over the equivalent number of rows.

=OFFSET('Recipe Calculation'!$D$106,COLUMN()-4,0)

....the result of Sheet1, Row106 and Column4 is dead on, but when I want to
copy the above function to the other cells of Column4 on Sheet2, the result
is always the same as on the first cell. What am I doing wrong?

I can't get my head around this and the Excel Help file is not much better
than the Excel book I have. Please help.

Thanks in advance...Carlos

 

[Ragdyer]

Try this instead:

=INDEX('Recipe Calculation'!$106:$106,ROW(4:4))

And copy down as needed.

 

[CF]

Thanks RD, that worked...Carlos

Try this instead:

=INDEX('Recipe Calculation'!$106:$106,ROW(4:4))

And copy down as needed.
--
HTH,

RD

-------------------------------------------------------------------------- -
Please keep all correspondence within the NewsGroup, so all may benefit !
-------------------------------------------------------------------------- -

 

[RagDyeR]

Appreciate the feed-back.