The ADDRESS function is designed to get a cell address in Excel based on the specified row and column numbers. A cell address is returned as a text string, not an actual reference.
Purpose of Excel ADDRESS Function
ADDRESS function returns the address for a cell based on a given row and column number.
Return value
Function returns a cell address as text, based on a row and column number. It can return an absolute or relative address, in A1 or R1C1 style. A sheet name can also be included in the result.
Syntax
=ADDRESS (row_num, col_num, [abs_num], [a1], [sheet])
Arguments
| Arguments | Description | Remarks |
| row_num | The row number to use in the cell address. | Mandatory |
| col_num | The column number to use in the cell address. | Mandatory |
| abs_num | The address type (i.e. absolute, relative). Defaults to absolute. | Optional |
| a1 | The reference style, A1 vs R1C1. Defaults to A1 style. | Optional |
| sheet | The name of the worksheet to use. Defaults to current sheet. | Optional |
Availability
Since 2007 for Windows.
Since 2011 for Mac.