Microsoft Office Tutorials and References
In Depth Information
Finding Where It Is
Only the first two arguments are required. These are the row number and
column number being addressed. The function returns the specified
reference as text. Table 14-1 shows a few examples of using the ADDRESS function.
Table 14-1
Using the ADDRESS Function
Syntax
Result
Comment
=ADDRESS
(5,2)
$B$5
Only the column and row are
provided as arguments. The
function returns a full absolute
address.
=ADDRESS
(5,2,1)
$B$5
When a 1 is used for the third
argument, a full absolute
address is returned. This is the
same as leaving out the third
argument.
=ADDRESS
(5,2,2)
B$5
When a 2 is used for the third
argument, a mixed reference is
returned with the column
relative and the row absolute.
=ADDRESS
(5,2,3)
$B5
When a 3 is used for the third
argument, a mixed reference
is returned with the column
absolute and the row relative.
When a 4 is used for the third
argument, a full relative
reference is returned.
=ADDRESS
(5,2,4)
B5
When the fourth argument is
false, an R1C1 style reference
is returned.
=ADDRESS
(5,2,1,0)
R5C2
This example tells the function
to return a mixed reference in
the R1C1 style.
=ADDRESS
(5,2,3,0)
R[5]C2
=ADDRESS
(5,2,1,,”Sheet4”)
Sheet
4!$B$5
The fifth argument returns
a reference to a worksheet
or external workbook. This
returns an A1 style reference
to cell B5 on Sheet 4.
=ADDRESS
(5,2,1,0,”Sheet4”)
Sheet
4!R5C2
This returns an R1C1 style
reference to B5 on Sheet 4.
Search JabSto ::




Custom Search