Numbers REFERENCE.NAME: Cell Addresses, Header Names and INDIRECT

• Introduced: The original introduction release and date are not established by the checked references.
• Availability: Currently documented in Apple’s Functions Help 15.4 documentation edition; no final supported-version endpoint is established.
• Scope: Shared iWork reference. Individual historical Mac, iPad, iPhone and iCloud endpoints and imported-workbook parity remain unverified.
• Checked: October 14, 2026, against the official REFERENCE.NAME reference. Coordinate, array-shape and text models were independently checked; no native Numbers test was performed.

REFERENCE.NAME(reference, reference-specificity, reference-style)

All three arguments are optional in Apple’s reference:

The referenced cell may contain any value or be empty. If the formula itself is in a header cell, Apple specifies A1 style even when header-name style is selected. The output therefore depends on the formula’s placement as well as the explicit arguments.

Create a sheet named Report and a table named Metrics on it. Give the table six columns A:F and twelve rows, with exactly one header row, one header column and no footer row.

Put Measure in A1, December in B1, Note in C1, Address in D1 and Check in E1. Put Sales in A2, numeric 1250 in B2, and the literal text B2 in B3. The B3 input contains two characters without enclosing quotation marks; it is not a formula.

The intersection of column header December and row header Sales is B2. These names reproduce Apple’s header-name convention while the numeric value gives a separate retrieval check.

Enter these formulas in D2:D8:

D7 follows Apple’s whole-column example. D8 follows its address-text example: INDIRECT reads B3’s text B2 as a reference, then REFERENCE.NAME describes that reference using header names. The value 1250 is not incorporated into any address string.

In E2 put =ISTEXT(D2) for TRUE. E3 =LEN(D3) gives 2. E4 =LEN(D4) gives 11, and E5 =LEN(D5) gives 19. These ASCII character counts include both colons in each separator.

In E8 enter =INDIRECT(D3) for 1250. D3 contains B2, so this local address resolves to the original numeric cell. In E9 enter =INDIRECT(D5) for 1250, using the fully specified address with the exact sheet and table names above.

This round trip separates two operations: REFERENCE.NAME produces text describing a reference; INDIRECT interprets address text and retrieves its target. Plain text that resembles an address is not automatically a live cell reference in every formula.

Avoid circular references. These results point back to B2, not to the cells containing the address-building or retrieval formulas.

In F1, which is a header cell, enter =REFERENCE.NAME(B2,0,0). Apple’s header-cell exception gives the expected text B2, despite the explicit header-name style 0. D2, in the body, still displays December Sales.

Create a separate table named SelfAddress, with three columns and four rows and zero header rows, header columns and footer rows. In B2 enter =REFERENCE.NAME() for the expected text B2. There are no applicable header names, and the omitted reference is the formula’s own cell.

In C2 put =ISTEXT(B2) for TRUE. In B3 enter =REFERENCE.NAME(B2,0,1) for B2. This explicit form describes the address of B2, not the address-like text stored inside it. No second level of address interpretation occurs unless it is requested with another function.

Keep Metrics unchanged. On Report, create a separate table named HeaderChanges, with five columns and six rows, one header row and one header column. Put December in B1, Sales in A2 and 1250 in B2. Use D2 =REFERENCE.NAME(B2), D3 =REFERENCE.NAME(B2,0,1), D4 =REFERENCE.NAME(B2,1,1) and E3 =INDIRECT(D3).

Initially D2 is December Sales, D3 is B2, D4 is HeaderChanges::B2, and E3 is 1250. Change only B1 to January and A2 to Revenue. The header-based D2 is now expected to be January Revenue, while the two explicit A1-style strings remain unchanged.

Next change only B2 from 1250 to 1300. E3 becomes 1300, but the address strings do not change. Header text, cell coordinates and stored values are different pieces of information; choose which one a report actually needs.

Apple says that adding categories or filters retains the original references in the returned string. Do not interpret an address as a visible row ordinal after filtering. The examples here do not exercise those interfaces or claim that every structural edit, rename or imported reference behaves identically.

ISTEXT identifies a text result and LEN counts its graphemes. Exact quoting of unusual table names, duplicated or empty header labels, invalid mode values and cross-document references remain outside these controlled names and documented examples.

English formulas here use commas between arguments. Apple’s syntax guidance uses semicolons when the decimal separator is a comma. Keep table references local as instructed, and select cells with the formula editor if imported names or qualifiers differ.