ADDRESS Function
The ADDRESS function is one of the lookup and reference functions. It is used to return a text representation of a cell address.
Syntax
ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
The ADDRESS function has the following arguments:
Argument |
Description |
row_num |
A row number to use in a cell address. |
column_num |
A column number to use in a cell address. |
abs_num |
A type of reference. The possible values are listed in the table below. |
a1 |
An optional logical value: TRUE or FALSE. If it is set to TRUE or omitted, the function will return an A1-style reference. If it is set to FALSE, the function will return an R1C1-style reference. |
sheet_text |
The name of the sheet to use in a cell address. It's an optional value. If it is omitted, the function will return the cell address without the sheet name indicated. |
The abs_num argument can be one of the following:
Numeric value |
Meaning |
1 or omitted |
Absolute referencing |
2 |
Absolute row; relative column |
3 |
Relative row; absolute column |
4 |
Relative referencing |
Notes
How to apply the ADDRESS function.
Examples
The figure below displays the result returned by the ADDRESS function.
Return to previous page