Note:ADDRESS
Description
ADDRESS creates a cell address as text.
Syntax
ADDRESS ( row, column, ref_type [, A1] [, sheet] )
|
Parameter |
Description |
|
|
row |
The row number for the cell address. |
|
|
column |
The column number for the cell address. |
|
|
ref_type |
The cell reference type. Following are the valid values for this argument. |
|
|
|
Value |
Description |
|
|
1 (or not indicated) |
Absolute |
|
|
2 |
Absolute row, relative column |
|
|
3 |
Relative row, absolute column |
|
|
4 |
Relative |
|
A1 |
The reference format. This argument must be TRUE( ) to represent an A1 reference format. The R1C1 reference format is not supported. |
|
|
Sheet |
The name of an external worksheet view control. Omitting this argument assumes that the reference exists in the current spreadsheet. |
|
Examples
This function returns $F$5:
ADDRESS(5, 6, 1)
This function returns SALES!F5:
ADDRESS(5, 6, 4, TRUE(), "SALES")
Note:
If an Invalid formula syntax warning appears, check whether the comma is set as the list separator in your regional settings on the Windows Control Panel. If a different character is set as the list separator, use this character in the above examples in place of the comma. (Windows XP: Access the Windows Control Panel and select Regional and Language Options. On the Regional Options tab page, click Customize. On the Numbers tab page, check which character is the default list separator on your computer. Use this character in the above examples instead of the comma.
Also, see