yogi_Pull Values From Info1 And info2 Sheets Into Results Sheet For Specified Fields

                                           Google Spreadsheet   Post  #833
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Oct 27, 2012
user a2b said: (http://productforums.google.com/forum/?zx=7nbhfu4macmk#!category-topic/docs/spreadsheets/L31smuqVXqE)
merging sheets
Chrome browser

Mac OS

I have a file (see link)

https://docs.google.com/spreadsheet/ccc?key=0Av87k6S9hZaqdF85akVUOHRhWG5TMmpCTnF5MkZWMFE

with 2 sheets, each has different info about students

The only shared info is the student name

How do I put his data togethor on a third sheet, importing all relevant info per student name

thank you

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

following is a solution based on my understanding from your scan description