Question: Is this feature possible in Numbers?
Is it possible to enter info in one cell and have a neighbouring cell automatically populate with different predefined information?
Example: I have a cell which I have created a popup menu of product options. Is it possible, after choosing one of the popup options "Product A", to have the cell next to it look up a price and populate itself with product A's dollar value?
Cheers in advance