Create drop down list with options from cell range

Discussion in 'Mac Apps and Mac App Store' started by tommy060289, Dec 23, 2012.

  1. tommy060289 macrumors regular

    Jun 20, 2011
    Hey everyone,

    I am creating a Diet diary and I intend to use the spreadsheet to create a meal by selecting ingredients from the drop down menu (e.g. if I wanted to check total content of breakfast, I might select some cereals in row 1 and milk in row 2). I intend to use the VLOOKUP function to do most the work but the bit im having trouble finding is making the first cell a drop down list. I know I can do it from pop-up menu in inspector but that means I have to enter all the options in to the list. I want the options in the drop down list to be just everything from the Column A in a table.

    How do I do this?



Share This Page