REFERENCE.NAME
The REFERENCE.NAME function returns a string representation of the given cell reference.
REFERENCE.NAME(reference, reference-specificity, reference-style)
reference: An optional cell reference. The referenced cell can contain any value, or be empty. If reference is omitted, the cell containing the formula is used.
reference-specificity: An optional modal value that determines the amount of information to return in the string.
cell (0 or omitted): Return only the cell address.
table (1): Return the table name and cell address.
all (2): Return the sheet name or slide number; table name; and cell address.
reference-style: An optional modal value that determines the naming style of the returned string.
header-names (0 or omitted): Return the header names representing the cell reference if applicable.
A1 (1): Return the cell in the A1 form.
Notes
If REFERENCE.NAME is used in a header cell, reference-style defaults to A1, even if header-names is selected.
If categories or filters are added to a table, REFERENCE.NAME keeps the original cell references, so the returned string isn’t affected. This allows REFERENCE.NAME to be used with functions such as INDIRECT.
Examples |
---|
Let column B’s header name be "December", row 2’s header name be "Sales", and B3 be "B2". =REFERENCE.NAME(B2) returns "December Sales". =REFERENCE.NAME(B2, 2) returns "Sheet 1::Table 1::December Sales". =REFERENCE.NAME(B) returns "December". =REFERENCE.NAME(INDIRECT(B3)) returns "December Sales". |