ADDRESS Formula

The ADDRESS formula is available in the Lookup/Reference Function category in Excel. This for is used to get cell address on the base of row number and column number.

Syntax of ADDRESS formula

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

Parameters Details:

row_num : The row number to use in the cell address.
column_num : The column number to use in the cell address.
abs_num : Optional. It is the type of reference to use. If this parameter is omitted, it assumes that the ref_type is set to 1. It can be any of the following values:

  • 1 : Absolute referencing. For example: $A$1
  • 2 : Relative column; absolute row. For example: A$1
  • 3 : Absolute column; relative row. For example: $A1
  • 4 : Relative referencing. For example: A1

a1: Optional. It is the reference style to use: either A1 or R1C1. If this parameter is omitted, it assumes that the ref_style is set to TRUE. It can be any of the following values:

  • TRUE : A1 style referencing
  • FALSE: R1C1 style referencing
sheet_text: Optional. It is the name of the sheet to use in the cell address. If this parameter is omitted, then no sheet name is used in the cell address.

Returns

The ADDRESS function returns a string/text value.

Example of Address Formula
Example of Address Formula