ADDRESS

Purpose:
ADDRESS function helps in obtaining the address of a cell in a worksheet based on the row and column numbers specified.

Command:
=ADDRESS(row_num,column_num,[abs_num],[a1],[sheet_text])
(Please note: Syntax specified in bracket [ ] are optional requirements)

Here:
row_num        - Refers to row number required in the cell for reference
column_num   - Refers to column number required in the cell for reference
abs_num        - Type of reference to be returned. This is specified in a numerical form as shown below:

• 1 or None - Absolute (both Row & Column)
• 2               - Absolute row, Relative Column
• 3               - Absolute Column, Relative Row
• 4               -  Relative (both Row & Column)

[a1]               - Refers to a logical value that specifies either A1 or R1C1 reference style.

• In A1 style, the column is specified alphabetically, while the row is specified in numbers
• In R1C1 style, both row & column are specified in numbers

[sheet_text]   - This is specified by a text value & specifies the name of the worksheet

Example:

Enter following values in excel:

Command	Value Returned	What does it mean?
=ADDRESS(5,3)	$C$5	Both Row & Column with Absolute Reference
=ADDRESS(5,3,3)	$C5	Absolute Column & Relative Row
=ADDRESS(5,3,3,0)	R[5]C3	Absolute Column & Relative Row in R1C1 reference style
=ADDRESS(5,3,1,0,"[Report]Daily Report")	'[Report]Daily Report'!R5C3	Absolute Reference to Workbook named "Report" & Worksheet named "Daily Report"
=ADDRESS(5,3,1,0,"Weekly Report")	'Weekly Report'!R5C3	Absolute Reference to a Worksheet named "Weekly Report"

Please see Image below: