Excel OFFSET function

Function              OFFSET

Description        Excel OFFSET function creates an offset to original cell and returns the value from offset cell. Positive offset in rows is downward, negative is upward, positive offset in columns is towards right, negative is toward left.

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

reference  The original cell, input as a cell reference or range.

rows  The number of rows to offset below or above the reference.

cols  The number of columns to offset to the right or left of the reference.

height  [optional] The height in rows of the returned reference.

width  [optional] The width in columns of the returned reference.

Example: