The ADDRESS function returns the cell address based on the specified row and column numbers.
This function can be useful for creating dynamic formulas where references change automatically.
Syntax
ADDRESS(row_num, column_num, [reference_type], [reference_style], [sheet_name])
Argument |
Description |
Permitted values |
|---|---|---|
row_num |
Row number used in the cell reference |
Any integer greater than 0 or a reference to a cell containing a number |
column_num |
Column number used in the cell reference. The first column corresponds to number 1 |
Any integer greater than 0 or a reference to a cell containing a number |
[reference_type] |
(optional) Type of reference to be returned: •1: Absolute row and column (for example, $A$1). •2: Absolute row and relative column (for example, A$1). •3: Relative row and absolute column (for example, $A1). •4: Relative column and row (for example, A1). By default, 1 |
1, 2, 3, 4 |
[reference_style] |
(optional) Style of reference to be returned: A1 (TRUE) or R1C1 (FALSE). By default, TRUE
|
TRUE or FALSE |
[sheet_name] |
(optional) Name of the sheet to which the reference leads. |
Text string with the name of the sheet, for example, “Sheet1” |
Examples of use
Simple absolute address
=ADDRESS(5, 3)
Result: $C$5.
Relative address
=ADDRESS(2, 4, 4)
Result: D2.
Address with the name of the sheet
=ADDRESS(10, 2, 1, TRUE, "Sheet 1")
Result: Sheet1!$B$10.
Notes
–When using optional parameters, follow the order in which they are specified.
–The reference type determines how the reference behaves when the formula is copied.