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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
