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.

Slouch1802 Author

Level 1

8 points

Numbers Help

In numbers if I set up pop up menus relating to different products, can I then have the value of said product automatically pop up in the cell next door?

iPad Pro, iOS 12

Posted on Jun 10, 2019 5:16 AM

Top-ranking reply

Yellowbox

Level 7

21,331 points

Posted on Jun 12, 2019 4:26 AM

Hi Slouch 1802,

I got this to work on an iPhone, but I find it easier to post screen shots from a version on my Mac.

In Table 1, cell A2 is a Pop-Up Menu

Formula in cell B2 of Table 1 =IF($A2="Select a product","Nothing selected",VLOOKUP($A2,Lookup Prices::A:B,2,0))

Regards,

Ian.

View in context

Numbers Help

Similar questions