Create drop down list with auto pricing

Hi Nick,

If you have a Price list, consisting of a list of items in one column and a list of your current price for each of those items in an adjacent column, you can use the item names in a popup menu cell to Lookup the item selected in the popup menu, and return the price recorded for it there.

Here's an example:

All data on the Price List table is entered directly.

The formula shown below Table 1 is entered as shown in cell B2 of Table 1, and filled down to the last row of that table.

Each cell in the body (rows 2 to 11) of Table 1 contains a copy of the same popup menu.

To create it, I entered the name of each item in the column in the order I wanted them to appear in the popup menu.

With all the items listed, selected all of the cells containing an item name, then opened the Format Inspector, selected Cell, then set the data format of the cell to Popup Menu.

Regards,

Barry

Numbers does not have a feature called "dropdown menu." It does have a data format called Pop-Up Menu. Is that what you mean?

Go to Help > Numbers Help in your menu and search for 'pop-up menu'.

The values in a pop-up menu cannot be linked to values in cells.

SG