Im making a worksheet to calcualte the overall nutritional makeup of a meal by adding up the individual ingredients nutritional information. As ill be using it every day i see no point in having to continually reenter ingredients names and their nutrient values when i think i can make a simple excel database to store various foods and their values. I know its possible to filter such databases in excel but what i really want is to either

1) be able to select from a drop down list the ingredients ive entered in the database when im adding them to my MEAL worksheet

or

2)Simply have the worksheet autocomple the ingredients name and the nutrient columns as i type the ingerdients name in.

Is this possible?