How to find and automatically fill excel

sheet1 contains sheet2 figure (not in the order, otherwise the situation may be the same name), how to achieve sheet2 in the number of school sheet1 to automatically find the appropriate person (date of birth and address of the request to be consistent) and Sheet2 will be in the student code to automatically fill sheet1 “school code” corresponding out of position up?
Excel file, see (wuyinggang77@126.com Drafts of “on-line question”, password:000000)
Trouble trouble

well, in the Drafts.