Is it possible to have cells change automatically if another cell's pop-up menu is changed?

You could use the INDIRECT function in the table where you select the header column from the original table using the Pop-Up menu, like this:

First create the Pop-Up menu in the header row of the Origin table.

Next copy/paste the Pop-Up menu cell in the header cells of the table "Column selection by Pop-Up" from column B to e.g. column D in this second table:

The two left header columns from both tables have to be identical: ROW2 ... ROW9.

I put the following formula in the cells B2 to D9 of the second table:

INDIRECT("Origin::"&D$1&" "&$A4;)

You can now select columns in the second table by using the Pop-Up menu in the header row cells of the second table.

Enjoy.

Paul.

If you want the table to "look up" the data for the item based on the item name, that is a very common thing to do in spreadsheets. Below is an example with two cells of information for each item, easily expanded to seven.

The Product Data table is all manually typed in. This is the data for each item.

In Table 1,

Column A is formatted as popup menu with the three item names

Column B formula =IF($A2<>"",XLOOKUP($A2,Product Data::$A,Product Data::B,"Not Found"),"")

Fill that to the right and fill down to complete the rest of he table

One way to create a pop-up of a long list of items:

1. Put the list of items in a column of a table and sort them into the order you want them to appear in the menu. In the example above, the items are already in column A of in the Product Data table so I would just use that column.
2. Select all of the cells that you want in the pop-up menu.
3. Change the format to pop-up menu. This will format all those cells as pop-up menus with all the selected items in the menu. You may not want this column of cells to be pop-ups; you can reverse this later.
4. Copy one of the cells.
5. Use Undo (Cmd Z) to change the format of the column back to what it was.
6. Paste the pop-up to where you need it.

Other cells can change depending on the choice you make in a Pop-Up Menu cell. You would put a formula in the dependent cells, typically using IF.

But it is not possible via formula to have Pop-Up Menu cells change the value of other Pop-Up Menu cells, in a sort of "cascading menu."

SG