Description
This function generates a cell address as text, given specified row and column numbers. ADDRESS(RN,CN,AN,A1,CText)
>where RN is the row number ,CN is the column number to use in the cell reference.
AN specifies the type of reference to return.
|
AN |
types of reference |
|
1 or omitted |
Absolute |
|
2 |
Absolute row,relative column |
|
3 |
Relative row,absolute column |
|
4 |
Relative |
A1 is a logical value
CText is text specifying the name of the calcisheet to be used as the external reference.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | TABLE3!$C$4 | |||
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
Let's see an example in Column1Row1
I.e.=ADDRESS(4,3) is TABLE3!$C$4
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | TABLE4!C$4 | |||
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
=ADDRESS(4,3,2) is TABLE3!C$4)