The ADDRESS function in Excel returns a text representation of a cell address from specified row and column numbers.
The syntax for the ADDRESS function is:
=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
Argument | Purpose |
---|---|
row_num | The row number to use in the cell reference |
column_num | The column number to use in the cell reference |
abs_num | The type of reference to return. If omitted, Excel assumes an absolute cell reference1 – Absolute2 – Absolute row; relative column3 – Relative row; absolute column4 – Relative |
a1 | The reference style to be used. If omitted, Excel assumes the A1 styleTRUE – A1FALSE – R1C1 |
sheet_text | The name of the worksheet to be used. If omitted, no worksheet name is used |
The examples below show different uses of the ADDRESS function.
Function | Result |
---|---|
=ADDRESS(4, 3) | $C$4 |
=ADDRESS(4, 3, 3) | $C4 |
=ADDRESS(4, 3, 1, FALSE, “QTR 3”) | ‘QTR 3’!R4C3 |