Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.
תחביר
OFFSET(reference, rows, cols, [height], [width])ארגומנטים
referenceחובה
The starting reference from which you want to base the offset.
rowsחובה
The number of rows, up or down, that you want the upper-left cell to refer to.
colsחובה
The number of columns, to the left or right, that you want the upper-left cell to refer to.
The OFFSET function does not move any cells or change the selection; it simply returns a reference. It is a volatile function that recalculates every time the worksheet changes, making it useful for creating dynamic ranges.
=OFFSET(A1, 2, 1)→B3Returns the value in the cell two rows down and one column to the right of A1.
Define the base reference
Select the starting cell or range that will serve as the anchor for your offset.
Specify the offset distance
Enter the number of rows and columns to move from the base reference.
Yes, OFFSET recalculates every time any change is made to the worksheet, which can slow down large workbooks.