Excel's OFFSET function lets you create a reference that isquite literallyoffset from a starting point. It allows references to adjust dynamically to changes in your spreadsheet's data and structure.

Alternatively, you can click the Insert Function button all the way to the left of the ... with the formula, and Excel will change your cell references to match. For example, when the formula ...