You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

JDALESSI Author

Level 1

4 points

Numbers - Pop Up Menu formula and process

Hi,

First let me give you some context.

I have created a family budget to track all my spending.

I download all the raw data from the bank statements and populate a spreadsheet.

Once populated with the data, I then am I'm trying to link my pop up menu creation (i.e. category) selections and their respected monetary values (below) to calculate in another cell. Keep in mind I'm trying to ensure that whatever pop up menu selection is selected it will change on the cell I want it to calculate towards.

Hope this makes sense. Tried Apple Support on the phone and they we unable to help me.

Thanks in advanced.

Cheers,

Josh