ExcelFunctions.net Logo

The Excel ADDRESS Function

Home » Excel-Built-In-Functions » Excel-Lookup-And-Reference-Functions » Excel-Address-Function



Search this site:
Custom Search

Basic Description

The Excel Address function takes row and column numbers and returns a cell reference as a text string.

The format of the function is:

ADDRESS( Row_num, Column_num, [Abs_num], [A1], [Sheet_text] )

Where the arguments are as follows:

Row_num - The row number to use in the reference
Column_num - The column number to use in the reference
Abs_num - An optional argument, which specifies whether the reference should contain absolute or relative references. Abs_num can take on the following values :
1 - denotes absolute row & column reference
2 - denotes absolute row & relative column reference
3 - denotes relative row & absolute column reference
4 - denotes relative row & column reference
If this argument is omitted, it takes on the default value 1 (absolute references)
A1 - An optional logical argument that defines the style of the Ref_text reference.
This can be either :
  • True - to denote that the reference is in A1 style
  • False - to denote that the reference is in R1C1 style
If this argument is omitted, it takes on the default value "True"
(For more details, see the page on Excel Reference Styles)
Sheet_text - An optional text argument that specifies the sheet name.
If this argument is omitted, the sheet name is blank (ie. the reference relates to the current worksheet)


Examples

The following spreadsheets show simple examples of the Excel Address function. The format of the function is shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

 Formulas
Example of use of the Excel Address Function 		 Results
Excel Address Function Results


Note that cell A5 in the above spreadsheet combines the ADDRESS function with the ROW function and the COLUMN function to display the reference to the current cell.






Valid XHTML 1.0 Transitional

Disclaimer Privacy Policy
Copyright © 2008-2010 ExcelFunctions.net