What Is the ADDRESS Function in Excel?

To obtain the address of a worksheet in Excel. ADDRESS function is used. You must give the specific row and column number to locate the cell. If we define it in a general sense, the ADDRESS function is handy when there is no way out to refer to a particular cell address.

Purpose of ADDRESS Function

The only purpose of this Excel function is to provide the address of any cell in the worksheet. The address of the cell is then shown as a text string.

Syntax of ADDRESS Function

The syntax of the ADDRESS function is as below.

=ADDRESS (row_num, column_num, [abs_num], [a1], [sheet-text])

Arguments

The following arguments are acceptable by the ADDRESS function.

  • Row_Num: this is the number of the row in the cell reference.
  • Column_Num: this is the number of the column in the cell reference.

The above-mentioned arguments are a compulsory part of the ADDRESS function. The last three arguments abs, a1, and sheet text are optional arguments.

  • Abs-Num: this numeric value defines what type of value will be returned.
  • A1: this specifies the reference style. There are two types of reference styles in Excel. One is known as a1 style and the other is known as R1C1.
  • Sheet_text: it is a text value that shows the name of the worksheet that is used for external reference.

Example

Consider the following example to show how the formula of the ADDRESS function is written.

Suppose that the row is 11, the column is 13, abs_num=3, a1 is 1, and the sheet name is ABC sheet.

The formula will be written as follows.

“= ADDRESS (11, 13, 3, 1, “ABC sheet”)”.