Friday, May 31, 2013

yogi_Based On dropDown Selection In Sheet1!B1 LookUp The Values In Cells B2 And C2

                                          Google Spreadsheet   Post  #1225
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   May 31, 2013
user blixel (!mydiscussions/docs/Z8W-45RIq2A)
How to fill a cell based on drop down selection?
I have 2 sheets in a spreadsheet.

On Sheet1 I have a drop down menu to select 1 of the planets. (Mercury, Venus, Earth, and so on)

On Sheet2, I have the radius and mass of each planet  in a list.

When I select a planet from the drop down menu, I want the target radius and target mass cells to be updated accordingly.

So if I select Mars from the drop down menu, then on Sheet2, the target radius becomes B7, and the target mass becomes C7. I don't know how to update the target based on the menu drop down selection.

Here is a copy of the spreadsheet for your consideration.