OFFSET function


Returns a reference to a range that is given a number of rows and columns from a given reference.



=OFFSET( referencerowscols[height][width] )


required arguments:

reference The starting point supplied as a cell reference or range.
rows The number of rows to offset below the starting reference.
cols The number of columns to offset to the right of the starting reference.


optional arguments:

[height] The height in rows of the returned reference.
[width] The width in columns of the returned reference.