ADDRESS
returns a cell address as text from row and column numbers · from excel · excel: verified match · sheets: verified match
signature
ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
returns: text
| argument | required |
|---|---|
| row_num | required |
| column_num | required |
| abs_num | optional · defaults to 1 |
| a1 | optional · defaults to 1 |
| sheet_text | optional · defaults to 0 |
examples
formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.
fx
=ADDRESS(2, 3) $C$2 fx
=ADDRESS(2, 3, 4, TRUE, "Sheet2") Sheet2!C2 related
- AREAS returns the number of areas in a reference
- HLOOKUP searches first row and returns matching value
- HYPERLINK the text a link displays — clickability is the renderer's
- INDEX returns value at row and column in range
- INDIRECT returns reference specified by text string
- LOOKUP looks up value in one-row or one-column range