2 Replies Latest reply: May 13, 2013 2:53 PM by Jerrold Green1
bmlabelle Level 1 (0 points)

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


Numbers, OS X Mountain Lion (10.8.3)
  • bmlabelle Level 1 (0 points)

    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,

  • Jerrold Green1 Level 7 (29,960 points)

    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