ADDRESS Function in Google Sheets: Syntax, Examples & Troubleshooting
Build cell-address text from numeric coordinates, control absolute references and use lookup results without confusing text with a live reference.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: ADDRESS converts a row number and column number into cell-address text. For example, =ADDRESS(9,3) is expected to return $C$9. It describes a cell; it does not fetch that cell’s value.
Availability and version history
- Introduced: Original introduction date is not established by the official history reviewed.
- Availability: Documented in the rolling Google Sheets service. This guide covers ordinary worksheet formulas in the web workflow; it does not establish separate mobile or connected-database behavior.
- Checked: October 14, 2026, against the official ADDRESS reference. Documentation and independent calculations; no native application execution.
Syntax and reference modes
=ADDRESS(row,column,[absolute_relative_mode],[use_a1_notation],[sheet])
Row and column are numeric coordinates; column A is 1. The default absolute/relative mode is 1, and the default notation is A1. The sheet name is omitted unless supplied as text.
The four modes control dollar signs: 1 fixes row and column, 2 fixes only the row, 3 fixes only the column, and 4 fixes neither. FALSE for use_a1_notation requests R1C1-style text. Keep argument positions intact when using later optional parameters.
Example 1: inspect all four A1 modes
Enter each formula in a separate cell:
=ADDRESS(9,3,1)
=ADDRESS(9,3,2)
=ADDRESS(9,3,3)
=ADDRESS(9,3,4)
The expected strings are $C$9, C$9, $C9 and C9. All identify the same coordinates in this simple case. Their distinction matters when that address is used as part of a formula that is copied to another position.
The dollar signs are characters in the returned string. ADDRESS itself does not copy a formula or lock an input cell. This is especially important when inspecting results that look like active references but are actually text.
Example 2: column numbers beyond Z
=ADDRESS(4,26,4)
=ADDRESS(4,27,4)
=ADDRESS(4,52,4)
=ADDRESS(4,53,4)
The expected results are Z4, AA4, AZ4 and BA4. Column numbering is one-based and uses alphabetic labels without a zero character. AA is column 27, not column 26 or column 101.
This is useful when assembling an audit report from numeric column indices. There is no need to invent a custom letter-conversion formula for ordinary worksheet addresses.
Example 3: make the coordinate inputs visible
Enter F2=12 and G2=5, then enter:
=ADDRESS(F2,G2,4)
The expected text is E12. Change G2 to 6 and the expected text becomes F12. Changing the formula’s own position does not change those explicit coordinate inputs.
For an R1C1 control, =ADDRESS(12,5,1,FALSE) is expected to return R12C5. This example uses absolute R1C1 coordinates; relative R1C1 offsets and the receiving formula’s interpretation should be tested separately before migrating complex generated formulas.
Advanced example: report the address of a matched item
On a separate sheet, enter headings Item and Units in B2:C2, then enter Pen,12, Pad,5, Box,7 in B3:C5. Enter Pad in F2:
=ADDRESS(MATCH(F2,B3:B5,0)+2,3,4)
The expected result is C4. MATCH finds Pad at relative position 2 in B3:B5; adding 2 converts that position to worksheet row 4. Column 3 selects the Units column C.
For Pen the result is C3; for Box it is C5. The adjustment of 2 comes from this table’s first data row, so do not copy the constant unchanged if the table moves. The MATCH guide explains the exact-match zero argument.
If you need the unit count instead of address text, use =INDEX(C3:C5,MATCH(F2,B3:B5,0)), expected 5 for Pad. INDEX retrieves a value directly. Building address text first is unnecessary for that task.
Sheet names, errors and verification
The optional fifth argument identifies a sheet by name. It does not select the fourth notation argument. Use explicit intervening arguments or the documented empty argument positions so that a sheet name is not accidentally interpreted as a Boolean flag.
ADDRESS returns text, so concatenating two addresses can create a text label for a range but does not sum that range. A separate function such as INDIRECT interprets reference text when that is genuinely required.
Use valid positive coordinates and check the source of calculated row and column numbers. This guide does not claim a native boundary/error-code matrix or exact sheet-name quoting behavior for unusual names. All stated address strings and match-position arithmetic were independently derived, without Google Sheets execution. Formulas use an English-locale comma separator.