Saturday, November 24, 2012

yogi_Find Associated Name And Number In A Cell And Put The Number Into The Column Dedicated To The Name


                                          Google Spreadsheet   Post  #890

              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 25, 2012
user Guy Pilkinton said:(http://productforums.google.com/forum/?zx=jnm1y5sz2w47#!category-topic/docs/spreadsheets/_mUbRmTuHvk)
Find a name and number in a cell and put the number into the column dedicated to the name.
Hi I want to Find Names and numbers in a cell which includes other text. Then I want to put the number into a cell column headed with the name. 

I want a funtion that will mean L4 reads "7", M5 reads "4", and N6 reads "7".  Is there a function that will automatically do this for me?
-------------------------------------------------------------------------------------------------
following is a solution to the problem ... there is a slight discrepancy in your expected response, so I have altered the names in row 1 to match your expected response