|Dec 23, 2012, 05:57 PM||#1|
Create drop down list with options from cell range
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?
|Thread Tools||Search this Thread|
|thread||Thread Starter||Forum||Replies||Last Post|
|I Need to Create a Website Quick! Best Options? ((No Tumblr) I Just Bought a Domain))||HappyDude20||Community Discussion||3||Mar 25, 2013 05:03 PM|
|What be the best way to create an app with a list of editable items||fstigre||iPhone/iPad Programming||14||Nov 24, 2012 07:52 PM|
|Create files from list in CSV||jasperx||Mac Programming||22||Oct 19, 2012 09:27 PM|
|Looking to create a backup of Aperture. Should I use a vault or drag and drop?||Star Nuts||MacBook Pro||0||Aug 31, 2012 12:11 PM|
|iPhone: Why doesn't Safari/Mail give me Page Range print options?||Mazda 3s||Jailbreaks and iOS Hacks||1||Jul 22, 2012 04:54 PM|
All times are GMT -5. The time now is 06:06 PM.