Need advice on Excel course

please guys help me am taking this course in excel and am about to fail it

my instructor gave us this bonus assignment to get more marks

if i didnt get this assignment right am gonna fail the course so please help

and of course my instructor always gives us these HARD assignments



ok the assignment is:


in this work book we have 2 sheets

sheet 1: you'll find all the semester the student took and in each all the courses


sheet 2:you'll find all the students ID and all the courses and the grades for the courses


what he want is:>>>>>>>>>>>


in sheet 1 when i write the student ID it should show me all the grades for the courses he took in each semester and also the extra ones


i hope i made it clear for you guys i think i should use (VLOOKUP) but what do i know