As a new user of pages and converting from word and excel I am used to using pivot tables in word to create a document.
Is there a way to use a formula such as vlookup to pick up data using a link to a numbers sheet. I have a problem filling in the column range in the table in pages to look at another document in numbers.
Thanks anyone from a frustrated searcher for a solution 😁
MacBook Pro, OS X Yosemite (10.10.5)
No release of Pages v5 provides linking to Numbers spreadsheets, or any other documents. Pages and Numbers are not clones of Word and Excel.
In Pages v5.6.1 (El Capitan 10.11.1), I have successfully tested a VLOOKUP between a visible table, and an invisible Rates table.
The Rates table is changing the Table name to Rates, and it is a 10 row, 2 column table. The first column has all cells formatted as percent, and the second column formatted as numbers that will be returned to the cell with the VLOOKUP formula. In this example, I did not use any conditionals to determine the specific value for the VLOOKUP. In the following, I have hidden the Rate table outline, and the individual row/column lines. I have temporarily revealed the table name, and cell contents before I uncheck the former, and set the Text color of the cells to white for total concealment. One can infer the VLOOKUP formula for the other cells based on the first.
Linking Pages and Numbers files
