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

Question:

Question: Is this feature possible in Numbers?

Hello...


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

Posted on

Reply
Question marked as Solved
Answer:
Answer:

Hi g,

User uploaded file

In Table 2, A2 is a Pop-Up-Menu containing the values in Table 1 Column A.

Formula in B2 of Table 2 =VLOOKUP(A2,Table 1::A:B,2)


Both tables have Header Rows.


Regards,

Ian.

Posted on

Page content loaded

User profile for user: gjmnz

Question: Is this feature possible in Numbers?