ADDRESS

ADDRESS - this function returns a cell address (reference) as text, according to the specified row and column numbers. You can determine whether the address is interpreted as an absolute address (for example, $A$1) or as a relative address (for example, A1) or in a mixed form (for example, A$1 or $A1). You can also specify the name of the sheet.

Syntax:

ADDRESS(row; column; abs;sheet)

row represents the row number for the cell reference

column represents the column number for the cell reference (the number, not the letter)

abs determines the type of reference:

1: absolute ($A$1)

2: row reference type is absolute; column reference is relative (A$1)

3: row (relative); column (absolute) ($A1)

4: relative (A1)

sheet represents the name of the sheet. It must be placed in double quotes.

Example:

=ADDRESS(10;40;1;"Sheet2") will return Sheet2.$AN$10


Screen shot: