ADDRESS

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]	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).	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”

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.

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.