Newbie: Help with OFFSET function

C

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
 
R

Ragdyer

Try this instead:

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

And copy down as needed.
 
C

CF

Thanks RD, that worked...Carlos


Ragdyer said:
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 !
-------------------------------------------------------------------------- -
Click to expand...
 
Top