Returns a cell reference as a string.

Sample Usage

ADDRESS(1,2)

ADDRESS(1,2,4,FALSE)

ADDRESS(1,2,,,"Sheet2")

Syntax

ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet])

  • row - The row number of the cell reference
  • column - The column number (not name) of the cell reference. A is column number 1.
  • absolute_relative_mode - [ OPTIONAL - 1 by default ] - An indicator of whether the reference is row/column absolute. 1 is row and column absolute (e.g. 1), 2 is row absolute and column relative (e.g. AA1), and 4 is row and column relative (e.g. A1).
  • use_a1_notation - [ OPTIONAL - TRUE by default ] - A boolean indicating whether to use A1 style notation (TRUE) or R1C1 style notation (FALSE).
  • sheet - [ OPTIONAL - absent by default ] - A string indicating the name of the sheet into which the address points.

Notes

  • When using optional parameters such as sheet, ensure that commas are inserted to indicate which parameter is being set.

See Also

OFFSET: Returns a range reference shifted a specified number of rows and columns from a starting cell reference.

MATCH: Returns the relative position of an item in a range that matches a specified value.

INDEX: Returns the content of a cell, specified by row and column offset.

Examples

Returns the cell address (reference) as text, according to the specified row and column numbers, using different types of reference.