Help - Public School Parent ...class list question

Greetings Everyone -

I have spent time on youtube watching videos and still can't quite get to the last step / formula that I need. My guess is that it is some sort of embedded Lookup functionality. Here goes.

I have a Master Sheet that includes each student name and contact info (first, last, parent name, email, adddress, etc.) There is also a column for Teacher. I need to generate individual Class Lists/ Sheets for each teacher. I need a formula on each class list page that goes to the Master, picks up all students related to the teacher name (at the top of the sheet) and also returns all of the contact info. The Master Sheet should be the only input sheet. Classes I would like to be locked and printed only. Yes - the screams for a database but we are a public school with 15 or so people on the PTA board who need to be able to enter and change data on the Master. We also dont have the money to invest in building a database.

The goal is to fill out each individual Class Sheet (1-206, 1-207, 1-208, etc) with all contact info for children with the same teacher. Traditional Lookup function only returns the first student.
Ideally, the Master Student List is the only thing that changes and the Class Sheets are locked and not able to be changed manually. I need capacity for up to 35 students in each class, although some are as small as 20
The Master Student list is a moving list (addition and deletion of rows, changing grade numbers to move up each year, teacher name changes), etc
There are 28 classes with 750 student entries. The model currently uses a pivot table and then you have to create new sheets for each class everytime a change is made. Not ideal

Any help would be greatly appreciated.
Thanks
Erin

Try

in A6

=IFERROR(INDEX('MASTER STUDENT LIST'!F$3:F$500,SMALL(IF(('MASTER STUDENT LIST'!$C$3:$C$500=$B$2)*('MASTER STUDENT LIST'!$D$3:$D$500=$C$2),ROW($A$3:$A$500)-ROW($A$3)+1,""),ROWS($A$3:A3))),"")

Enter with Ctrl+Shift+Enter

Copy across and down

I put Class in B2 and teacher in C2 (of "1-206" tab)

Two points:

You have a different formula (ranges) for each year: you only need one formula with maximum likely range in "MASTER STUDENT LIST"

And the ROW($A$3:$A$471) must the same range as F$3:F$1113

=IFERROR(INDEX('MASTER STUDENT LIST'!F$3:F$1113,SMALL(IF(('MASTER STUDENT LIST'!$C$3:$C$1113=$B$2)*('MASTER STUDENT LIST'!
$D$3:$D$1113=$C$2),ROW($A$3:$A$471)-ROW($A$3)+1,""),ROWS($A$3:A3))),"")

so with a likely maximum of (say) 3000 students set formula as:

=IFERROR(INDEX('MASTER STUDENT LIST'!F$3:F$3000,SMALL(IF(('MASTER STUDENT LIST'!$C$3:$C$3000=$B$2)*('MASTER STUDENT LIST'!
$D$3:$D$3000=$C$2),ROW($A$3:$A$3000)-ROW($A$3)+1,""),ROWS($A$3:A3))),"")

Use this same formula in EVERY sheet.

Obviously change 3000 to what you consider to be your maximum.

You missed adjusting the ROW range...
ROW($A$3:$A$913)

You could also just take them down to 1000, it's a nice round number and easy to "spot"

edit: lol echo, John meat me to it - on both suggestions