Excel Help

#1
See pic below to understand what I am talking about.
http://imgur.com/ZO6NTfd

I need help with making a drop down box. The drop down box would be placed in A2. The drop down box would contain apple, orange and grape.

When I choose from the drop down box (either apple, orange and grape) I would like their corresponding weight and height displayed in B2 (weight) and C2 (height) respectively.

How should I go about doing this?

Thank you!
 
Last edited: