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.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.