OFFSET
Returns a reference offset from a given reference by a specified number of rows and columns
Syntax
OFFSET(reference, rows, cols, [height], [width])
Parameters
- reference: Required. The reference from which you want to base the offset
- rows: Required. The number of rows to offset (positive=down, negative=up)
- cols: Required. The number of columns to offset (positive=right, negative=left)
- height: Optional. The height, in number of rows, of the returned reference
- width: Optional. The width, in number of columns, of the returned reference
Example
=OFFSET(A1, 2, 3, 1, 1)