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.
A
B
C
D
1
$C$2
2
3
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.
| Formula | Excel shows | Case |
|---|---|---|
=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 .