ADDRESS

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

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

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)

The reference style to use:

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

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

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

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.