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