returns a cell address as text from row and column numbers · from excel · excel: verified match · sheets: not yet compared

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.

related

• AREAS returns the number of areas in a reference
• HLOOKUP searches first row and returns matching value
• 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
• MATCH returns position of value in a range