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.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How to relate each with value on Numbers

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

Posted on Jul 9, 2020 7:48 PM

Reply
Question marked as Top-ranking reply

Posted on Jul 9, 2020 8:02 PM

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?

1 reply
Question marked as Top-ranking reply

Jul 9, 2020 8:02 PM in response to Ddiyanahalim

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

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.