Ah. Sounds like you need to remove the absolute reference.
=OFFSET('Sheet 2'!D1,0,'Ref'!$A$1)

Putting this in D1, and then copying to say, E1, would change formula to:
=OFFSET('Sheet 2'!E1,0,'Ref'!$A$1)

Is this what your're looking for?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"txm49" wrote:

Luke M: - Thanks for getting back so quickly.

Actually, its more complicated than I portrayed. The formula is actually:
=OFFSET('Sheet 2'!$D$1,0,'Ref'!$A$1)

Sheet 2 being a separate sheet with an array of data.
'Ref'!$A$1 is a changeable numeric value based on data vintage.

Keep in mind that the 'Sheet 2'! Cell address is different for each formula
I intend to change. I really don't want to change anything in 'Sheet 2'
since I concatenate various columns to perform lookups.

"Luke M" wrote:

In cell D1, type
=E1
Then copy this cell to all the other cells with your offset formulas. Excel
will figure out that you want each of these cells to reference the cell 1 to
the right.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"txm49" wrote:

I have a similar formula in multiple cells: =OFFSET($D$1,0,1). However, the
cell address in the first part of the formula varies by cell. for example,
in another cell, the formula might be =OFFSET($D$22,0,1). I just want the
formula to equal the cell address after the work "OFFSET", not an offset
function. How do I do this without editing each individual cell?