Ask Your Question
0

Calc Drop Down List

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

ieduardoms gravatar image

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

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

Comments

(removed my comment now URL deleted)

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

1 Answer

Sort by » oldest newest most voted
0

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

karolus gravatar image

Hallo

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 879 times

Last updated: Jul 15 '15