Absolute absolute cell reference

[jon west]

Is there a way of defining a cell to reference (eg. just
equal) another cell absolutely, even if rows or columns
are inserted in between.

For example:

Cell A1 you define =C1
If you insert a column between A and C I still want A1 to
reference the new C1 not D1

($s don't do this)

 

[Andy B]

jon

Use the OFFSET function. Try this in A1:
=OFFSET(A1,0,2)

Andy

 

[Peo Sjoblom]

Use indirect

=INDIRECT("A1")