Q: How can I use a pop up menu to change values in Numbers?
I would like to use a pop up menu to show different values based on what I select.
example: projects
sheet 1: projects to complete, broken down by supplies, each supply has the price. I currently have this set to show me all resources neede to complete everything, I'd like to set it up so I can choose from a pop up a character, building, etc and have it show me how much is needed for that.
Posted on May 22, 2016 4:50 PM
Hi Blackjack,
Here is an approach that should do what you want. As Numbers encourages multiple tables I created a report table to do what you are asking. It would work the same if you kept it in your original table. I added a footer for "totals" that sums the columns.
My popup in the report table has all the values in Table 1 column A and "totals" instead of "Everything"
The formula is filled across.
You can accomplish the same with LOOKUP() but I find the INDEX MATCH combo more flexible and easier to fill.
quinn
Posted on May 23, 2016 6:20 PM


