Practice free

ADDRESS function

ADDRESS builds a cell reference as text from a row number and a column number. It is often combined with INDIRECT, or used to show where a MATCH landed.

Example

Read it as a sentence: build the cell address for row 2 and column 3, which gives $C$2.

Practice this in the app

Syntax

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

Arguments in [square brackets] are optional.

row_num (required)
Row number.
column_num (required)
Column number.
abs_num (optional)
1 absolute (default), 2 absolute row only, 3 absolute column only, 4 relative.
a1 (optional)
TRUE or omitted for A1 style; FALSE for R1C1.
sheet_text (optional)
Sheet name to include in the address text.

Returns: A cell address as text.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=ADDRESS(2,3) $C$2 Default absolute
=ADDRESS(2,3,2) C$2 Abs row, rel col
=ADDRESS(2,3,4) C2 Relative
=ADDRESS(2,3,1,FALSE) R2C3 R1C1 style
=ADDRESS(2,3,4,FALSE) R[2]C[3] R1C1 relative
=ADDRESS(2,3,1,TRUE,"Data") Data!$C$2 With sheet name
=ADDRESS(1,16385) #VALUE! Column past XFD
=ADDRESS(0,1) #VALUE! Row 0

Watch out for

  • The result is text, not a live reference, until wrapped in INDIRECT.
  • Default includes dollar signs, e.g. $C$2.

Where it works

Excel
ADDRESS is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Lookup and reference functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .