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    Nov 25, 2012
user Guy Pilkinton said:(!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