How to use OFFSET function in Excel 2013

The OFFSET function returns a cell or range of cells that is a specified number of rows and/or columns from the reference cell.

IMPORTANT NOTES:

• If either of the “rows”, “columns”, “height” or “width” components are left blank, Excel will assume its value to be zero. For example, if the formula is written as OFFSET(D20, , 1, , ) Excel will interpret this as OFFSET(D20, 0, 1, 0, 0). This can also be written as OFFSET(D20, , 1) since “height” and “width” can be omitted.
• Note that if “height” and “width” are included in the formula, they cannot be equal zero or a #REF! error will result.