Sunday, November 25, 2012

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    Nov 25, 2012
user Beno Pileggi said:(!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,
Here is the spreadsheet:

I wrote a further explanation in the spreadsheet.

With Thanks,

following is a solution to the problem