Article updated on March 27, 2018

The ADDRESS function returns the address of a specific cell, you need to provide a row and column number.

Formula in cell D3:


Excel Function Syntax

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


row_num Required. A number representing the row number.
column_num Required. A number representing the column number.
[abs_num] Optional. Lets you choose the type of reference to return.
1 - Absolute.
2 - Absolute row, relative column.
3 - Absolute column, relative row.
4 - Relative.
[a1] Optional. Lets you choose reference style. A1 reference style is the default setting you are probably used to. The R1C1 reference style has both columns and rows are labeled numerically.
TRUE - A1-style reference.
FALSE - R1C1-style reference.
[sheet_text] Optional. A text value that specifies the name of the worksheet to be used as the external reference. =ADDRESS(1,1,,,"Sheet2") returns Sheet2!$A$1. If omitted the function refers to a cell on the current sheet.