ADDRESS

See also A-Z Spreadsheet Function List

Description Creates a cell address as text.

Syntax ADDRESS(row, column, ref_type [, a1] [, sheet])

row is the row number for the cell address.

column is the column number for the cell address.

ref_type is the cell reference type. The following table lists the values for this argument.

Argument Reference type

1 Absolute

2 Absolute row, relative column

3 Relative row, absolute column

4 Relative

a1 is the reference format. This argument must be TRUE() to represent an A1 reference format; Formula One does not support the R1C1 reference format.

sheet is the name of an external spreadsheet. Omitting this argument assumes that the reference exists in the current spreadsheet.

See Also COLUMN , OFFSET , and ROW functions

Examples ADDRESS(5, 6, 1) returns “$F$5”

         ADDRESS(5, 6, 4, TRUE(), “SALES.VTS”) returns “SALES.VTS!F5”