OFFSET

Definition: OFFSET is a function that returns a reference to a range that is offset from a starting cell reference.

Syntax: =OFFSET(reference, rows, cols, [height], [width])

Situation: This formula is appropriate when you need to return a reference to a range that is offset from a starting cell reference.

Example: If you have a data table and want to return a reference to a range that is two rows down and three columns to the right of cell A1, the formula =OFFSET(A1, 2, 3) can be used.