ADDRESS in Excel: Build A1 and R1C1 Reference Text

• Introduced: Original introduction release not established by the official history reviewed.
• Availability: official help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
• Checked: October 14, 2026; official ADDRESS reference. Documentation check; examples independently calculated, not native-tested.

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

The first two arguments identify the worksheet row and column. abs_num controls the reference markers: 1 is fully absolute, 2 fixes the row only, 3 fixes the column only, and 4 is fully relative. Omitted abs_num uses 1. The a1 argument defaults to TRUE for A1 notation; FALSE produces R1C1 notation. The optional final argument adds a sheet name. Official ADDRESS reference

The output is text that describes a reference. ADDRESS does not retrieve the value at that location, select the cell, or create the named worksheet.

=ADDRESS(7,28)

Expected result: $AB$7. Column 26 is Z, column 27 is AA and column 28 is AB. The dollar signs indicate that both row and column are absolute in the returned A1 reference text.

Compare =ADDRESS(7,26) and =ADDRESS(7,27): their expected results are $Z$7 and $AA$7. This makes ADDRESS safer than a one-character column-letter calculation when columns extend past Z.

Use these formulas in separate cells:

The numeric row and column identify the same position in all four cases. Only the reference markers change. Returning relative-looking text does not itself move the target when you fill the ADDRESS formula; copied numeric arguments and cell references follow their own formula rules.

=ADDRESS(7,28,1,FALSE)

Expected result: R7C28. The first coordinate is the row, and the second is the column. This example uses absolute R1C1 notation deliberately.

Relative R1C1 forms use bracketed offsets, so they should not be read as ordinary absolute worksheet coordinates. Choose the notation expected by whatever will consume the returned text instead of removing markers by guesswork.

=ADDRESS(7,28,1,TRUE,"Sales Q1")

Expected result: ‘Sales Q1’!$AB$7. The single quotes protect the sheet name containing a space. The exclamation mark separates the worksheet name from its cell address.

The sheet name is supplied as a text argument in double quotes. ADDRESS constructs the text even though constructing it is not proof that the sheet exists or that AB7 contains a value.

For this test, create a worksheet named Sales Q1 and put numeric 48 in its AB7 cell. On another worksheet enter:

=INDIRECT(ADDRESS(7,28,1,TRUE,"Sales Q1"))

Expected result: 48. ADDRESS constructs the reference text; INDIRECT interprets that text as a reference and retrieves its value. Testing the inner ADDRESS expression alone should still return the text address, not 48.

For this fixed known target, a direct reference such as ='Sales Q1'!AB7 is simpler. An INDEX-based selection can also avoid manufacturing a text reference. Use the ADDRESS/INDIRECT combination when text construction is genuinely needed, and check INDIRECT’s platform and external-workbook restrictions.

Use positive row and column coordinates within the destination worksheet’s limits. This guide’s examples stay well inside those limits. A text string that resembles a plausible address does not certify that an external workbook is available or that a sheet name is correct.

Keep the distinction between worksheet coordinates and positions within a smaller table: the fifth column inside D:H is worksheet column H, whose absolute column number is eight. If your inputs are table-relative positions, convert them deliberately before passing them to ADDRESS.

• INDIRECT in Excel
• INDEX in Excel
• MATCH in Excel

Verification: These are fictional inputs and independently calculated expected results, not native Excel observations. See the editorial testing standards.