Skip to content
Excel

ADDRESS function in Excel

Returns a reference as text to a single cell in a worksheet

=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])

ADDRESS syntax and parameters

Five arguments, two required.

  • row_numnumberRequired

    A numeric value that specifies the row number to use in the cell reference.

  • column_numnumberRequired

    A numeric value that specifies the column number to use in the cell reference.

  • abs_numnumberOptional

    A numeric value that specifies the type of reference to return.

  • a1anyOptional
  • sheet_textanyOptional

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 Google Sheets

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 Excel gets this done.