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
Newsroom Update
The redesigned iPad Air and new iPad Pro with Apple silicon are now available. Learn more >
The redesigned iPad Air and new iPad Pro with Apple silicon are now available. Learn more >
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
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.
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.
Numbers Help