This Excel tutorial explains how to use the Excel OFFSET function with syntax and examples.
The Microsoft Excel OFFSET function returns a reference to a range that is offset a number of rows and columns from another range or cell.
The syntax for the Microsoft Excel OFFSET function is:
OFFSET( range, rows, columns, [height], [width] )
The OFFSET function can be used in the following versions of Microsoft Excel:
The OFFSET function can be used in Microsoft Excel as the following type of function:
Let's look at some Excel OFFSET function examples and explore how to use the OFFSET function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following OFFSET examples would return:
=OFFSET(A1, 1, 2, 1, 1) Result: reference to cell C2 (and thus would display $7.23) =OFFSET(C3, -1, -2, 1, 1) Result: reference to cell A2 (and thus would display 10567)
(scroll to see more)