Calc Drop Down List

Hello there,

I need to know how to create the functionality I have seen in this spreadsheet (see the below link).

(The question can be answered without visiting a commercial link! URL deleted. Lupp)

In this spreadsheet there is a sheet called “Nutrition Table” which contains a list of food and their nutritional values (calories, fat, protein, etc.)

There is another sheet called “Diet Plan” which contains several Drop Down List, these Drop Down List display all the food in the “Nutrition Table”, when I choose a food in a Drop Down List all the nutritional values are copied from “Nutrition Table” onto “Diet Plan”.

I need to know how to do it.

Thank you very much.

(removed my comment now URL deleted)


Try →Data→Validation...→Cellrange....