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

Level 3

858 points

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 Mar 10, 2018 9:53 PM

Best reply

Yellowbox

Level 7

20,329 points

Posted on Mar 12, 2018 12:55 AM

Hi g,

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.

View in context

Is this feature possible in Numbers?

Similar questions