yogi_Find The Number Associated With A Name In A DropDown List

                                          Google Spreadsheet   Post  #891

              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 25, 2012

user Beno Pileggi said:(http://productforums.google.com/forum/?zx=jnm1y5sz2w47#!category-topic/docs/spreadsheets/6nF8amG7MiM)
Question about data
Ok well, I am creating a question about spreadsheets, and I have a question about data.

In A1 I have a drop down menu with 10 separate values. For each of those values, there is another corresponding value. I would like the corresponding values to appear automatically once some one selects a value from the list in A1.

Thanks in Advance,

Ben

---

Here is the spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0ArRsrugbajYadEdQalVyNDlSSXhXcEpoX0lSWEFNRlE&pli=1#gid=0

I wrote a further explanation in the spreadsheet.

With Thanks,

Ben 

---------------------------------------------------------------------------------------------

following is a solution to the problem