Pop up Menu to trigger a value
I’d still call myself a beginner with Numbers, but trying to delve further. I’d like a pop up menu item to trigger a number in a different cell.
For example: I’d like to select “Annually” from a pop up menu, and have “12” populate in another cell. Which I’ll hide and use to run an “Average” equation somewhere else. I’d appreciate your thoughts, thanks.