Ask Your Question

Calc Drop Down List

asked 2015-07-15 06:44:31 +0200

ieduardoms gravatar image

updated 2015-07-15 11:20:16 +0200

Lupp gravatar image

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.

edit retag flag offensive close merge delete


(removed my comment now URL deleted)

Alex Kemp gravatar imageAlex Kemp ( 2015-07-15 06:47:44 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2015-07-15 08:41:39 +0200

karolus gravatar image


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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-07-15 06:44:31 +0200

Seen: 903 times

Last updated: Jul 15 '15