Apple Event: May 7th at 7 am PT
Hi, is it possible for me to create a popup menu along with value (price) on different cell?
For example, when I select “Sambal Tumis” the price will automatically show on the price cell.
Thanks in advance!
iPad Pro 10.5-inch, Wi-Fi, Cellular
Yes, Ddiyanahalim.
There are many times when it would be nice if one could place a Formula in one Cell that would "write" results in another Cell.
Unfortunately, that's not the way spreadsheet like programs work.
Now, are the Cells in your Order column "popup menus"?
You could place a lookup-like function, in the Price column Cells, that will look up and display the price, for the chosen Order item, from an auxiliary table (perhaps in another Sheet).
Do you know how to do something like that?
Yes, Ddiyanahalim.
There are many times when it would be nice if one could place a Formula in one Cell that would "write" results in another Cell.
Unfortunately, that's not the way spreadsheet like programs work.
Now, are the Cells in your Order column "popup menus"?
You could place a lookup-like function, in the Price column Cells, that will look up and display the price, for the chosen Order item, from an auxiliary table (perhaps in another Sheet).
Do you know how to do something like that?
How to relate each with value on Numbers
