Excel 2007 : excel experts plz i need help !!!!!

Hi,
This is a project in a university course and I have to create an advising system...The professor provided me with sheets called data 1 and data 2.......data 1 gives us the ID numbers of students,courses and grades....data 2 gives us the ID numbers of students and the courses they are currently taking in this semester........I wrote out the courses required to graduate from each business major....so when the professor puts the ID and major he wants to get the grades of courses taken before and the major....what I want your help in is the following..............I want excel to look at the courses that each student took but is not present in the business major table.I want it also to show it in a list.
plzzz if u can reply as soon as possible coz the deadline for submitting is after 6 hours from now..Thank you so much and I realy appreciate it.