ADDRESS

Returns the address of a cell with the specified column and row as text.

Syntax

ADDRESS( Integer row, Integer column, [Integer abs = 1], [Logical a1 = TRUE], [Text sheet] ) → Text

Parameters

row

Required. A numeric value that specifies the row number to use in the cell reference.

column

Required. A numeric value that specifies the column number to use in the cell reference.

abs

Optional. A numeric value that specifies the type of reference to return:

• 1 (or omitted) - Absolute
• 2 - Absolute row; relative column
• 3 - Relative row; absolute column
• 4 - Relative

a1

Optional. A logical value that specifies the A1 or R1C1 reference style. In A1 style, columns are labeled alphabetically, and rows are labeled numerically. In R1C1 reference style, both columns and rows are labeled numerically. If the a1 argument is TRUE (or omitted), the ADDRESS function returns an A1-style reference; if FALSE, the ADDRESS function returns an R1C1-style reference.

sheet

Optional. A text value that specifies the name of the worksheet to be used as the external reference. If the sheet argument is omitted, no sheet name is used.

Example

Formula

=ADDRESS(3,5)
=ADDRESS(3,5,2,FALSE)
=ADDRESS(3,5,,,"My Sheet")

See Also

Function Reference
INDIRECT Function