ADDRESS Function in Excel: Syntax, Examples and Free Practice
ADDRESS is an Excel Lookup & Reference function. Builds a cell address as text from a row and column number.
ADDRESS syntax
Arguments
row_num: Which row to returncolumn_num: Which column within the range to useabs_num: Whether the reference should be absolute or relative (optional)
When to use ADDRESS
ADDRESS is used to pull matching data from one part of a workbook into another.
Practice ADDRESS online, free
Open the live Excel-style spreadsheet and try ADDRESS yourself. No Excel install or sign-up needed to start.
Practice ADDRESS now →More Lookup & Reference functions
Frequently asked questions
What does the ADDRESS function do in Excel?
Builds a cell address as text from a row and column number.
What is the syntax of ADDRESS in Excel?
The syntax is =ADDRESS(row_num, column_num, [abs_num]). row_num: Which row to return; column_num: Which column within the range to use; abs_num: Whether the reference should be absolute or relative (optional).
Where can I practice ADDRESS online for free?
Open the free live spreadsheet on Cellgrids and try ADDRESS yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts