OFFSET()
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.
Important
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. ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.