Hey everyone I'm trying to put together a class roster as follows
I have the following tabs
course title (has a defined name for the list of course descriptions) with a second column of course codes
Student roster (has a list of all students with the courses they are signed up for, whether they take day, night, or mixed classes, and a grad year)

Course roster (this is what I need help with)
I want the course roster tab to let me pick from the pull down the course name and give the code for it (this part i have done)
Next I want it based on that course code to find from the student roster all of the students in that class
Then I want it to list the students with the courses they are in their class time and grad year

I'm pretty sure I've done something like this before using excel functions but for the life of me cannot remember how so any help would be appreciated
I also need it to still work even if the students have blanks in their schedules like in some of the cases

I am uploading a copy.
Course Sched.xlsx