ADDRESS function

Description

This ADDRESS function returns the address for a cell based on a given row and column number. For example, =ADDRESS(1,1) return $A$1. ADDRESS can return an address in relative of absolute format, and can be used to construct a cell reference inside a formula.

​

Objective

Create a cell address from a given row and column.

​

Syntax

=ADDRESS(row_num,col_num,[abs_num],[a1],[sheet],....)

​

Arguements

row_num - row number use in the cell address.

col_num - col number use in the cell address.

abs_num - [optional] the address type (i.e absolute, relative). Defaults to absolute.

a1 - [optional] the reference style, A1 vs R1C1. Default to A1 style.

sheet - [optional] the name of the worksheet to use. Default to current sheet.