Sign up for free
Functions

ADDRESS

Returns a text string that represents a cell reference based on the specified row and column numbers.

Parameter List

Syntax
ADDRESS(row, column, 
[reference_type]
, 
[a1_style]
, 
[sheet_name]
)
row

The row number to use in the cell reference. For example: 5 for row 5.

column

The column number to use in the cell reference. For example: 3 for column C (the 3rd column).

[optional] reference_type

The type of reference to return:

  • 1 (default) - Absolute reference ($A$1)

  • 2 - Mixed reference with absolute row (A$1)

  • 3 - Mixed reference with absolute column ($A1)

  • 4 - Relative reference (A1)

[optional] a1_style

The reference style to use:

  • TRUE (default) - A1 style (A1, B2, etc.)

  • FALSE - R1C1 style (R1C1, R2C2, etc.)

[optional] sheet_name

The name of the worksheet to reference. For example: "Sheet2". If omitted, no sheet name is included.

More details

The ADDRESS function is useful for dynamically creating cell references in formulas. The reference_type parameter controls whether the returned reference uses absolute ($A$1), mixed (A$1 or $A1), or relative (A1) addressing. When a1_style is FALSE, the function returns R1C1 style references instead of A1 style.

Examples

ADDRESS(1, 1) returns "$A$1", absolute reference to row 1, column 1.