Lookup & Reference
All versions
◉ 26 views
=ADDRESS()
You can use the ADDRESS function to obtain the address of a cell in a worksheet, given specified row and column numbers. For example, ADDRESS(2,3) returns $C$2. As another example, ADDRESS(77,300) returns $KN$77. You can use other functions, such as the ROW and COLUMN functions, to provide the row and column number arguments for the ADDRESS function.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
Hover argument names in the table for details.
Output typeText
Popularity25 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =ADDRESS() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
row_num |
Number | Required | A numeric value that specifies the row number to use in the cell reference. |
column_num |
Number | Required | A numeric value that specifies the column number to use in the cell reference. |
abs_num |
Number | Optional | A numeric value that specifies the type of reference to return. 1 or omitted = Absolute; 2 = Absolute row; relative column; 3 = Relative row; absolute column; 4 = Relative. |
a1 |
Logical | Optional | A logical value that specifies the A1 or R1C1 reference style. In A1 style, columns are labeled alphabetically, and rows are labeled numerically. In R1C1 reference style, both columns and rows are labeled numerically. If the A1 argument is TRUE or omitted, the ADDRESS function returns an A1-style reference; if FALSE, the ADDRESS function returns an R1C1-style reference. Note To change the reference style that Excel uses, click the File tab, click Options, and then click Formulas. Under Working with formulas, select or clear the R1C1 reference style check box. |
sheet_text |
Text | Optional | A text value that specifies the name of the worksheet to be used as the external reference. For example, the formula =ADDRESS(1,1,,,"Sheet2") returns Sheet2!$A$1. If the sheet_text argument is omitted, no sheet name is used, and the address returned by the function refers to a cell on the current sheet. |
▣ Examples
Absolute reference
=ADDRESS(2,3)
Result:
$C$2
Absolute row; relative column
=ADDRESS(2,3,2)
Result:
C$2
Absolute row; relative column in R1C1 reference style
=ADDRESS(2,3,2,FALSE)
Result:
R2C[3]
Absolute reference to another workbook and worksheet
=ADDRESS(2,3,1,FALSE,"[Book1]Sheet1")
Result:
'[Book1]Sheet1'!R2C3
Absolute reference to another worksheet
=ADDRESS(2,3,1,FALSE,"EXCEL SHEET")
Result:
'EXCEL SHEET'!R2C3
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!