Exceljet

Quick, clean, and to the point

Excel ADDRESS Function

Excel ADDRESS function
Summary 

The Excel ADDRESS function returns the address for a cell based on a given row and column number. For example, =ADDRESS(1,1) returns $A$1. ADDRESS can return an address in relative or absolute format, and can be used to construct a cell reference inside a formula.

Purpose 
Create a cell address from a given row and column
Return value 
A cell address in the current or given worksheet.
Syntax 
=ADDRESS (row_num, col_num, [abs_num], [a1], [sheet])
Arguments 
  • row_num - The row number to use in the cell address.
  • col_num - The column number to use in the cell address.
  • abs_num - [optional] The address type (i.e. absolute, relative). Defaults to absolute.
  • a1 - [optional] The reference style, A1 vs R1C1. Defaults to A1 style.
  • sheet - [optional] The name of the worksheet to use. Defaults to current sheet.
Usage notes 

Use ADDRESS to create an address from a given row and column number. For example:

ADDRESS(1,1) returns $A$1
ADDRESS(1,1,4) returns A1

Abs_num key:
1 or omitted  Absolute
2  Absolute row; relative column
3  Relative row; absolute column
4  Relative

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.