OFFSET

OFFSET —

OFFSET(range,row,col[,height[,width]])

OFFSET function returns a cell range. The cell range starts at offset (row,col) from range, and is of height height and width width.

If range is neither a reference nor a range, OFFSET returns #VALUE!.
If either height or width is omitted, the height or width of the reference is used.

COLUMN, COLUMNS, ROWS, INDEX, INDIRECT, ADDRESS.