Fonction Google Sheets

OFFSET

Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.

Générer une formule avec l'IA La même fonction dans Excel

Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.

Syntaxe

OFFSET(reference, rows, cols, [height], [width])

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.

Arguments

referenceobligatoireThe starting reference from which you want to base the offset.
rowsobligatoireThe number of rows, up or down, that you want the upper-left cell to refer to.
colsobligatoireThe number of columns, to the left or right, that you want the upper-left cell to refer to.

Exemples

=OFFSET(A1, 2, 1)

Résultat : B3

Returns the value in the cell two rows down and one column to the right of A1.

FAQ

Is OFFSET a volatile function?

Yes, OFFSET recalculates every time any change is made to the worksheet, which can slow down large workbooks.

Fonctions associées

INDEX INDIRECT CHOOSE