ADDRESS function


DESCRIPTION:

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

 

SYNTAX:

=ADDRESS( row_num, col_num[abs_num][a10][sheet] )

 

REQUIRED ARGUMENTS:

row_num

The row number to use in the cell address.

col_num

The column number to use in the cell address.

 

OPTIONAL ARGUMENTS:

[abs_num]

The address type.

[a10]

The reference style.

[sheet]

The name of the worksheet to use.