ADDRESS

Creates a cell address as text, given specified row and column numbers.

Syntax

ADDRESS(row_num,column_num,abs_num,a1,sheet_text)

Row_num   is the row number to use in the cell reference.

Column_num   is the column number to use in the cell reference.

Abs_num   specifies the type of reference to return.

Abs_num

Returns this type of reference

1 or omitted

Absolute

2

Absolute row; relative column

3

Relative row; absolute column

4

Relative


A1   is a logical value that specifies the A1 or R1C1 reference style. If a1 is TRUE or omitted, ADDRESS returns an A1-style reference; if FALSE, ADDRESS returns an R1C1-style reference.

Sheet_text   is text specifying the name of the worksheet to be used as the external reference. If sheet_text is omitted, no sheet name is used.

Examples

ADDRESS(2,3) equals "$C$2"

ADDRESS(2,3,2) equals "C$2"

ADDRESS(2,3,2,FALSE) equals "R2C[3]"

ADDRESS(2,3,1,FALSE,"[Book1]Sheet1") equals "[Book1]Sheet1!R2C3"

ADDRESS(2,3,1,FALSE,"EXCEL SHEET") equals "'EXCEL SHEET'!R2C3"