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
Bookmarks