Does anyone know how to use vlookup from a pop up menu to retrieve another pop up menu?

Question

bmlabelle Author

Level 1

0 points

Does anyone know how to use vlookup from a pop up menu to retrieve another pop up menu?

Numbers-OTHER, OS X Mountain Lion (10.8.3)

Posted on May 13, 2013 1:02 PM

Reply

Answer 1

bmlabelle Author

Level 1

0 points

May 13, 2013 1:24 PM in response to bmlabelle

To clarify,

I am making a estimating template. I want to have one pop up menu that lists supplier names, depending on which supplier I choose from this pop up menu, I want another pop up menu of that suppliers products to appear in another cell.

Thanks,

Reply

Answer 2

May 13, 2013 2:53 PM in response to bmlabelle

BM,

Pop-Up menu format is not dynamic. It is created in the Cells Inspector and can't be modified contingent upon the state of other cells.

You could program a table to list the options available for the previous selection, but it wouldn't be in the form of a Pop-Up.

Jerry

Reply