This function uses the row and column numbers to create a cell address in text.

Syntax

ADDRESS(row,column,absnum,a1style,sheettext)

Arguments

This function has these arguments:

Argument	Description
row	Row number in the cell reference
column8	Column number in the cell reference
absnum	[Optional] Type of reference to return; can be any of:
	Value - Type of Cell Reference Returned
	1 or omitted - Absolute
	2 - Absolute row, relative column
	3 - Relative row, absolute column
	4 - Relative
a1style	[Optional] Logical value that indicates whether the reference style is A1; if TRUE or omitted, the style is A1; if FALSE, then the style is R1C1
sheettext	[Optional] Name of the sheet to use as an external reference; if omitted, no sheet name is used

Data Types

Accepts numeric and string data. Returns string data.

Examples

ADDRESS(2,4,2,FALSE)

Version Available

This function is available in product version 2.0 or later.

See Also

COLUMNS | ROWS | INDEX | Lookup Functions