Excel tip: Relative references in named formulas
Named formulas can be very useful when your Excel workbook needs to contain many cells that use the same formula, but they are limited to containing static references. It is easy to get around this limitation by creating a self-referencing formula named “Self”:
=INDIRECT(ADDRESS(ROW(),COLUMN()))
You can then access other cells using the OFFSET
function, e.g. one cell to the left would be
=OFFSET(Self,0,-1)