ADDRESS(row_number, column_number, abs_mode)

The ADDRESS function calculates the location of a reference to a single cell and returns the location as text.

The row and column numbers determine the address and the mode number determines the mode. In Spreadsheet, for example, the row number will specify the row number of the spreadsheet, the column number will specify the column letter, and the mode number will specify whether the reference address is absolute or relative, according to the following key:

abs_mode

Reference

1

Absolute

2

Absolute row, relative column

3

Relative row, absolute column

4 or omitted

Relative

For example:

ADDRESS(1,1,1)  returns $A$1

ADDRESS(10,5,3) returns $E10

ADDRESS(100,200) returns GR100

See also:

Other lookup functions