ADDRESS Function
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 reference
|
a1 |
The reference style to be used. If omitted, Excel assumes the A1 style
|
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 |
Download the Excel Formulas Ebook for a fast and simple guide to the most useful Excel formulas.
Follow us on
