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
Question marked as
Best reply
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.