How to autofill using pop-up menu?
I’m new to Numbers and here’s what I would like to do… I would like to choose an item in my Pop-Up Menu and have it auto fill the next 2 cells from another table. More specifically, I have a Pop-Up Menu with a list of plants. I have another sheet with a table that has 3 columns; plant name, botanical name and properties. I would like to be able to choose a plant in the pop-up menu and have the other cells automatically fill with the botanical name and properties for each plant from the other table. Is this possible in numbers? Thanks in advance!