Ok I am trying to return a list of students names and their grades dependent on whether they are in a certain class or not. The idea is that I have a dropdown list for a teacher to pick a class and it will then show their list of students with the different grades.

I have tried adapting an INDEX formula but can't get it to work.