ADDRESS function

Category: Lookup and reference functions

What does this function do?

Gets the address of a cell to specify the row and column numbers.

Syntax:

ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])

• row_num (required): A numeric value that specifies the row number to use in the cell reference.
• column_num (required):  A numeric value that specifies the column number to use in the cell reference.
• abs_num (optional):  A numeric value that specifies the type of reference to return.

abs_num	Returns this type of reference
1 or omitted	Absolute
2	Absolute row; relative column
3	Relative row; absolute column
4	Relative

• a1 (optional): Indicates if the reference style is A1, otherwise the R1C1 reference style is used.
• sheet_text (optional): Text value that specifies the name of the worksheet to be used as external reference.

Examples:

=ADDRESS = (2,2) = $B$ 2
=ADDRESS = (2,2,2) = B$ 2
=ADDRESS = (2,2,3) = $B2
=ADDRESS = (2,2,4) = B2
=ADDRESS = (2,2,2, FALSE) = F2C [2]
=ADDRESS = (2,2,,, "Summary") = 'Summary'!$B$2