Return a value from a different worksheet
I am trying to associate cell values from a separate workbook file. In Excel I used the VLOOKUP. How do I do the same in Numbers?
MacBook
Your posted topic: "Return a value from a different worksheet"
Translated into Numbers vocabulary: 'Return value from a Table on a different Sheet (in the same document).
Can be done using a simple cell reference. The cell address must include the name of the Table and, if there is more than one table in the document with that name, the name of the Sheet.
To get the value from cell B2 on the same table: =B2
To get the value from cell B2 on a different table: =Table 2::B2
(where Table 2 is on the same Sheet, or where Table 2 is on a different Sheet, but is the ONLY table in the document named "Table 2"
To get the value from cell B2 on a different table on a different Sheet: =Sheet 2::Table 2::B2
(where there is More than one table in the document named "Table 2"
If all three parts of the cell address are included, Numbers will automatically drop the parts it does not need.
"I am trying to associate cell values from a separate workbook file."
Translates to Numbers vocabulary and simplifying the statement: 'I am trying to return a cell value from a separate Numbers document.
Can't be done by Numbers working on its own. Numbers documents cannot communicate with each other.
Possible paths to a solution:
- Redesign your Numbers document to place all sheets within a single document.
- Write an AppleScript to collect data from one Numbers Document and place it into your first document.
- Use an application more suitable to the job as you see it.
Regards,
Barry