Does anyone know how to use vlookup from a pop up menu to retrieve another pop up menu?
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.
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.
Retrieving data ...