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:
|
[a1]: | (Optional) An optional argument specifying the 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:
1 |
=ADDRESS(2, 3) |
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.”
1 |
=ADDRESS(4, 2, 2, TRUE) |
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.”
1 |
=ADDRESS(1, 1, 4, FALSE, "Sheet2") |
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.