ADDRESS
Returns a reference as text to a single cell in a worksheet.
Lookup & ReferenceLookup & Matching Essentials
What it does
Creates a cell reference as text, given a row and column number.
Syntax
ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
Arguments
row_num(number) — The row number to use.column_num(number) — The column number to use.abs_num(number) — Type of reference (1=Absolute, 4=Relative).
Examples
Create absolute reference
Get address for Row 2, Col 3.
FORMULA
=ADDRESS(2, 3)
RESULT
$C$2
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | $C$2 |