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?