Check out Using Multiple Tables And Lookup In Numbers at YouTube for closed captioning and more options.
Using Multiple Tables And Lookup In Numbers
Comments: 6 Responses to “Using Multiple Tables And Lookup In Numbers”
You can't populate a menu with contents from a table.
I have two tables, one is for Jan -Jun, the other is for July-Dec. I want to take the total sales from table 1, and have a formula add it to the sales for July-Dec to get a grand total. How can I do that?
Start a new formula. Type =. Click on the total in the first table. Type +. Click on the total in the second table.
Thank-you Gary, this, I think, is exactly what I need to keep track of behavior percentages of my students!! Awesome job!
Another great job; informative and fun use of tables in Numbers. Thanks for the learning opportunity.
How can you create a drop down/pop up menu of products in that column in the second table using the entries in table 1 ?