Excel > Functions

ADDRESS Function

The ADDRESS function in Excel returns a text representation of a cell address from specified row and column numbers.

The syntax for the ADDRESS function is:

=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])

Argument

Purpose

row_num

The row number to use in the cell reference

column_num

The column number to use in the cell reference

abs_num

The type of reference to return. If omitted, Excel assumes an absolute cell reference

  • 1 - Absolute
  • 2 - Absolute row; relative column
  • 3 - Relative row; absolute column
  • 4 - Relative

a1

The reference style to be used. If omitted, Excel assumes the A1 style

  • TRUE - A1
  • FALSE - R1C1

sheet_text

The name of the worksheet to be used. If omitted, no worksheet name is used

The examples below show different uses of the ADDRESS function.

Function

Result

=ADDRESS(4, 3)

$C$4

=ADDRESS(4, 3, 3)

$C4

=ADDRESS(4, 3, 1, FALSE, "QTR 3")

'QTR 3'!R4C3

Follow us on

Facebook  Twitter  You Tube 

Other Lookup & Reference Functions

Excel 2010 Superhero Course