Numbers - reference a sheet name

You can use the following as the canonical form for a reference in Numbers.

<SHEET>::<TABLE>::<CELL>

if you have a document with three sheets ("Sheet 1", "Sheet 2", and "Sheet 3") each with a single table named "Table 1",

then you can refer to

sheet 1, table 1, cell B5

using the reference:

"Sheet 1::Table 1:: B5"

the easiest way to see the format is to do a test where you select the destination cell, then type the equal sign ("="), then click the cell you want to reference, you can click the sheet , then click the cell in the target table

Hi arksent,

Follow Wayne's advice to find the reference, then place it into the INDIRECT function to make an "interactive" formula

Formula in C2 =INDIRECT("Sheet "&A2&"::"&"Table "&B2&"::"&"B5")

That formula will return the contents of Cell B5 in each Table 1 on Sheets 2, 3, 4 and 5.

To make the formula even more "interactive", you can include a column for the Cell

=INDIRECT("Sheet "&A2&"::"&"Table "&B2&"::"&C2)

Edit Columns A, B and C to return the values of other Cells.

Play and enjoy!

Regards,

Ian.