Function Reference: ADDRESS
| Syntax | |||||||||||||||||
| =ADDRESS(row_num,column_num,[abs_num],[a1,],[sheet_text]) | |||||||||||||||||
| Purpose / Description | |||||||||||||||||
| Returns a text string that represents a cell address, based on the entries provided. This address is not necessarily valid in the context of the current workbook, the function merely derives an address in a valid format. | |||||||||||||||||
| Arguments | |||||||||||||||||
| Name | Type | Description | |||||||||||||||
| row_num | number | A constant, reference or nested expression that returns the row number of the cell whose address is to be calculated. Any decimal portion of the value is ignored. | |||||||||||||||
| column_num | number | A constant, reference or nested expression that returns the column number of the cell whose address is to be calculated. Any decimal portion of the value is ignored. | |||||||||||||||
| [abs_num] | number | An optional constant, reference or nested expression that returns a flag to indicate whether the row and/or column should be absolute or not Any decimal portion of the value is ignored. Defaults to 1 if omitted.
|
|||||||||||||||
| [a1] | number | An optional constant, reference or nested expression that returns a flag to indicate whether the address should be given in A1 or R1C1 notation. Any decimal portion of the value is ignored. Defaults to 1 if omitted.
|
|||||||||||||||
| [sheet_text] | text string | An optional constant, reference or nested expression that returns the name of the worksheet upon which the theoretical cell is located. It may include a workbook name to generate an external reference. If an empty string is passed, or a reference to a blank cell, the address will be in the inter-sheet format, without a sheet name, such as !A1 This is a valid refers to address in a defined name, but not in a worksheet cell formula. | |||||||||||||||
| Return Values | |||||||||||||||||
| Type | Specific Value | Description | |||||||||||||||
| text string | A text string containing a validly formatted cell address in the selected address style and with he absoluteness of reference chosen. | ||||||||||||||||
| error | #VALUE! | If row_num, column_num, abs_num or a1 are not numbers and cannot be coerced to numbers. If row_num < 1 or >= 1048577 If column_num is < 1 or >= 16385 If abs_num < 1 or >= 5 if a1 is < 0 or >=2 |
|||||||||||||||
| error | Any errors referenced by arguments are returned due to propagation of error values. | ||||||||||||||||
| Notes / Comments / Advice / Warnings | |||||||||||||||||
| Note: | The address text returned conforms to the Excel addressing requirements in the notation given. It is not guaranteed to be a valid address. | ||||||||||||||||
| Comment: | can be useful in working with INDIRECT, and in some models where the user is to be referred to cells or ranges for action, but the target cell's address may evolve. | ||||||||||||||||
| Examples: | Open / download sample workbook: ADDRESS.xlsx | ||||||||||||||||