Syntax. OFFSET(reference,rows,columns,height,width)
Definition. This function returns a cell reference that is a specified number of rows and columns from a given reference.
Arguments
reference (required). The reference from which you want to base the offset, a reference to a single cell or to a range of adjacent cells. An argument with a different reference type causes the #VALUE! error.
If the argument is a named range, you need to press Ctrl+Shift+Enter after you enter the formula even if you enter the formula in a single cell. Otherwise you get an error.
rows (required). The number of rows that you want the upper-left cell of the range to be moved up or down.
columns (required). An expression that can be evaluated to an integer. ...
No credit card required