ADDRESS
Lookup & referenceExcel 2007Build a cell address as text from row and column numbers.
Syntax
ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
Examples
=ADDRESS(5, 3)
→ $C$5
Related functions
More Lookup & reference functions
Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.