I'm using an Index/Match formula to run down a column with teacher names. There are 8 teachers used multiple times in 82 rows. I want to search the column for a specific teacher, and have the corresponding student show up. Right now it just returns the first student on the list. How do I make it recognize that student was already listed and move on down the list to the next student in the next cell? So A2 on the teacher sheet populates with a student name. I want A3 to populate with the next student name. A2:A83 currently return the same student over and over.

=INDEX(StudentName, MATCH("TeacherName", TeacherName, 0))



StudentName and TeacherName are both set ranges from A2:A83 and G2:G83 on the my master sheet respectively. I'm trying to pull the information from a master sheet to a sub-sheet assigned to the teacher.