Skip to content
Google Sheets

ADDRESS function in Google Sheets

Returns a cell reference as a string.

=ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet])

ADDRESS syntax and parameters

Five arguments, two required.

  • rownumberRequired

    The row number of the cell reference

  • columnnumberRequired

    The column number (not name) of the cell reference. A is column number 1.

  • absolute_relative_modenumberOptional

    [ OPTIONAL - 1 by default ] - An indicator of whether the reference is row/column absolute. 1 is row and column absolute (e.g. $A$1), 2 is row absolute and column relative (e.g. A$1), 3 is row relative and column absolute (e.g. $A1), and 4 is row and column relative (e.g. A1).

  • use_a1_notationbooleanOptional

    [ OPTIONAL - TRUE by default ] - A boolean indicating whether to use A1 style notation (TRUE) or R1C1 style notation (FALSE).

  • sheetstringOptional

    [ OPTIONAL - absent by default ] - A string indicating the name of the sheet into which the address points.

ADDRESS examples

Formulas you'll actually reuse.

  1. The cell address of the biggest deal in column C (+1 skips the header row):

    =ADDRESS(MATCH(MAX(C2:C50), C2:C50, 0) + 1, 3)

    Result"$C$17"

  2. A relative reference on another sheet, ready to feed INDIRECT:

    =ADDRESS(2, 5, 4, TRUE, "Budget")

    Result"Budget!E2"

ADDRESS in Excel

Same name — your formula ports as-is.

Try ADDRESS in the playground

Edit the example — nothing to install.

Preloaded with the ADDRESS formula from Example 1 — change anything and watch it respond.

Loading the editor…

ADDRESS errors

What they mean — and the fixes.

  • #VALUE!

    row or column is 0 or negative — both are 1-based counts — or the absolute/relative mode isn't 1–4.

Related functions

More ways Google Sheets gets this done.