LookupLevel: ExpertAvailable in: Excel 2007+
In this article
- Syntax
- Examples
- Example 1
- Related functions
ADDRESS returns a cell reference as text from row and column numbers — often combined with MATCH to report “where” something is.
Syntax
=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
| Argument |
What it means |
abs_num |
1 absolute ($A$1), 4 relative (A1). |
Examples
Example 1
=ADDRESS(MATCH(MAX(E:E),E:E,0), 5, 4)
The cell holding the maximum, e.g. E142.
INDIRECT · MATCH · CELL
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this articleStuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong