ADDRESS function

Excel ADDRESS Function allows you to create a text representation of a cell’s address, based on specified row and column numbers. It’s like giving Excel a set of coordinates and having it return the cell’s address in text form.

Syntax

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

Arguments

row_num:The row number for which you want to find the cell address.
column_num:The column number for which you want to find the cell address.
[abs_num]:(Optional) An optional argument specifying the type of cell reference to return:
  • 1 or omitted: Relative cell reference (default).2: Absolute column and relative row.3: Relative column and absolute row.4: Absolute cell reference.
[a1]:(Optional) An optional argument specifying the reference style:
  • TRUE or omitted: A1 reference style (default).FALSE: R1C1 reference style.
[sheet]:(Optional) An optional argument specifying the sheet name or reference. If omitted, it refers to the current sheet.

How to use

Let’s understand how to use the ADDRESS function with some examples:

This formula will return the address of the cell in the 2nd row and 3rd column with the default A1 reference style. In this case, it would return “C2.”

Here, the function returns the address with an absolute column (column 2) and a relative row (row 4) using the A1 reference style. The result would be “$B4.”

This example returns an absolute cell reference in R1C1 style for cell A1 on “Sheet2.” The result would be “Sheet2!R1C1.”

These are just a few examples of how you can use the ADDRESS function to generate cell references in different ways. It can be especially useful when building dynamic formulas or creating custom cell references.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.