Reference Another Table or Sheet in Apple Numbers

Quick answer: Start a formula in the destination, then click the source cell, even if it is on another sheet. Numbers inserts table and sheet qualifiers. Its notation is Table::Cell or Sheet::Table::Cell; use a single colon only for the ends of a range.

Requirements and evidence

This guide targets Numbers for Mac 15.4, the edition identified by Apple’s Mac guide when checked on October 16, 2026. Check your installed version in Numbers → About Numbers. These are Mac instructions, not the iPhone, iPad or iCloud interface. English formulas below use commas; a document that uses decimal commas may require semicolons between arguments.

Testing disclosure: The instructions were checked against Apple documentation and the sample results were independently calculated. This workflow has not been tested in the Numbers application; no application screenshots are supplied.

This example links tables inside one Numbers spreadsheet. It does not establish a live connection to a separate .numbers file. Keep one authoritative input table and derive the report from it rather than manually copying a second set of values.

Build three small tables

Use a sheet named Inputs, with two tables. Rename table titles to Sales and Rates so the references are recognizable. The Sales table has one header row and A1:C5:

Product	Units	Unit price
Notebook	12	8
Pen pack	9	5
Folder	15	3
Desk mat	4	18

In Rates, enter A1:B2:

Setting	Value
Discount	0.10

The rate is a fraction: 0.10 means 10%. Create a second sheet named Report, with a table named Summary. Give Summary headers Product, Gross and Net in A1:C1 and four body rows. Leave B2:C5 empty initially. The expected gross figures are 96, 45, 45 and 72, totaling 258. After a 10% discount, the expected net figures are 86.4, 40.5, 40.5 and 64.8, totaling 232.2.

These deliberately small totals make it possible to catch a wrong table reference without trusting a complicated model.

Link the product and gross amount

1. In Summary A2, type =. Click the Inputs sheet and Sales A2, then press Return. The result should be Notebook.
2. In Summary B2, type = to start a formula. Select Sales B2, type *, then select Sales C2. Press Return.
3. Compare the result with 12 × 8 = 96. The equivalent explicit formula is =Inputs::Sales::B2*Inputs::Sales::C2.
4. Copy Summary A2:B2 to A3:B5 using ordinary copy and paste. Relative row references should produce the four product names and gross values listed above.

Apple documents selection-generated qualifiers and the double-colon notation in Calculate values using data in table cells. Clicking the source is preferable to guessing spelling when names contain spaces or punctuation.

Keep a shared rate fixed when copying

In Summary C2, calculate gross × (1 − discount). Use the local B2 gross cell and the shared Rates B2 input:

=B2*(1-Inputs::Rates::$B$2)

The dollar signs preserve both the column and row of the rate. You can set this in the Formula Editor by opening the reference token’s triangle and selecting Preserve Row and Preserve Column. Keep the local gross reference B2 relative. Copy C2 to C3:C5 and compare all four results, not only C2.

The distinction is intentional: each report row needs its own gross amount, but all four use the same rate. Without preserving the rate row, the second copied formula could point to an empty Rates B3 instead. That error may produce a plausible result, so visual plausibility is a poor test.

Change Rates B2 from 0.10 to 0.20. Expected net amounts become 76.8, 36, 36 and 57.6, totaling 206.4. Restore 0.10 afterward. This single-input test shows whether every row actually uses the common rate.

Understand the three reference levels

• B2 means a local cell in the formula’s table.
• Sales::B2 identifies a different table on the same sheet where that qualifier resolves the target.
• Inputs::Sales::B2 identifies both the sheet and table.

Apple’s reference syntax guide describes these qualifiers. The fully qualified form is especially helpful when several sheets contain tables named Sales. Do not replace Numbers’ double colons with an Excel exclamation mark. For a range, the endpoints still use a single colon: =SUM(Inputs::Sales::B2:B5) should return 40 units in this example. See the SUM guide for aggregation details.

Test copying, names and structural edits separately

Preserving a row/column reference is not a guarantee that every possible restructuring will retain your business meaning. Use this small test protocol before reorganizing a large model:

1. Record the four gross and net amounts and the current 10% rate.
2. Rename one source table using its title, then inspect an existing formula. Check that it still points to the intended table and all totals remain unchanged.
3. Copy a formula to a new report row and inspect its token targets. Confirm the product row moved while the shared rate stayed fixed.
4. If you insert a new product or move source rows, reconcile the product names against each amount again. A report tied to positions is not a lookup by product ID.
5. If you delete a referenced source, investigate the reported reference error. Recreating a table with the same visible name should not be assumed to reconnect every old formula automatically.

Avoid categories in this minimal model. Apple warns that adding a row within a referenced range in a categorized table can require changing the reference before the new row is included. If your real workbook uses categories, add an explicit new-row reconciliation check.

Troubleshooting

The formula shows text instead of calculating: Make sure it was entered through the Formula Editor, beginning with =, rather than stored as a quoted text label. Finish with Return.

The first row works but lower rows are wrong: Inspect the discount reference in every copied formula. Check both the preserved row and column, and confirm the local gross reference remains relative.

A reference picks the wrong Sales table: Rebuild it by selecting the intended sheet and cell. Keep the explicit sheet qualifier in your mental model even if the editor displays a readable token rather than exactly the typed string.

A total omits a new product: B2:B5 is a bounded range. Expand the source and report deliberately and update total ranges. A new row outside that range is not automatically part of the example.

You need a reference’s readable name: REFERENCE.NAME is a related inspection tool. It is not a substitute for choosing the correct source cell or for a product-ID lookup when row order can change.

The final audit is a source-to-result check: 40 units, 258 gross, 232.2 net at 10%, and 206.4 net at 20%. Those figures are independently calculated checkpoints, not reported native execution results.