Article ID: 324991 - View products that this article applies to.
This article was previously published under Q324991
This article describes how to use the OFFSET function to return the value of a cell that is a specified number of rows and columns away from a cell or range of cells that you referenced in an adjacent range.
Enter the following data into a blank Excel worksheet. You will use this data for all sample formulas in this article.
Collapse this tableExpand this table
Enter the following formulas into cell E2 (or any available blank cell):
Examples:When you use this formula, the OFFSET function returns the value of the cell that is located two rows down (2) and 1 row to the left (-1) of cell C2 (which is cell B4). The value in cell B4 is "101". Therefore, the formula returns "101".