ADDRESS

Syntax:

ADDRESS ( row-number , col-number [ , [ ref-type ] [ , [ A1-ref-style-flag ][ , sheet-name ] ] ] )

Description: Creates a cell address, given the specified row and column numbers.

Arguments:

Name

Type

Description

row-number

number

The number of the row.

col-number

number

The number of the column.

ref-type

number

The type of reference to return, as follows:

Value

Type of Reference Returned

1 or omitted

Absolute row and column

2

Absolute row; relative column

3

Relative row; absolute column

4

Relative row and column

A1-ref-style-flag

logical

The style of the reference. If TRUE or omitted, an A1-style reference (§3.17.2.3.1) is returned; otherwise, an R1C1-style reference (§3.17.2.3.2) is returned.

sheet-name

text

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

Return Type and Value: text – A cell address, given the specified row and column numbers.

However, if

  • row-number or col-number < 1, #NUM! is returned.

  • ref-type is outside the range 1–4, #NUM! is returned.

example: :In A1-reference style mode:ADDRESS(5,7,1) results in $G$5ADDRESS(5,7,2) results in G$5ADDRESS(5,7,3) results in $G5ADDRESS(5,7,4) results in G5ADDRESS(5,7,,,"Sheet1") results in Sheet1!$G$5

In R1C1-reference style mode:ADDRESS(5,7,1,FALSE) results in R5C7ADDRESS(5,7,2,FALSE) results in R5C[7]ADDRESS(5,7,3,FALSE) results in R[5]C7ADDRESS(5,7,4,FALSE) results in R[5]C[7]