ADDRESS

Using the Excel ADDRESS Function

Summary

The Excel ADDRESS function is used to obtain the address of a cell given column and row numbers. For example, =ADDRESS(5,10) would return $J$5. The cell address can be in the current sheet or another sheet.

Syntax

=ADDRESS (row_num, column_num, [abs_num], [a1], [sheet_text])

Syntax Breakdown

Row Num
Required. A number specifying the row number to use in the cell reference.

Column Num
Required. A number specifying the column number to use in the cell reference.

Abs Num
Optional. Used to specify the type of reference to return. The options are as follows:

Excel ADDRESS abs_num Options

A1
Optional. Specifies the A1 or R1C1 reference style.

The A1 style has the columns labeled alphabetically and rows labeled numerically. The ADDRESS function will return the A1 style if the A1 argument is omitted or TRUE.

The R1C1 has both columns and rows labeled numerically. The function returns the R1C1 style if the A1 argument is FALSE.

Sheet Text
Optional. Allows the user to find the address of a cell on another sheet. For example, =ADDRESS(2,2,,,"Sheet3) would return Sheet3!$B$2.

If the sheet_text argument is blank or no sheet name is used, the function will find the address of the cell on the current worksheet.


Usage Notes

Use the ADDRESS function to find the address for a cell by supplying the row and column number. The function can return the address of a cell on the current sheet or another user specified sheet. Addresses can be returned in relative or absolute value.