Looking at the spreadsheet you sent. I'm not sure how to make it apply to what I need. I only want one column of information to fill in on the subsequent sheets while pulling information from 2 columns in the mastersheet. I was looking at the following formula to try to alter it, but can't quite figure it out.

=IF($A3="","",INDEX(Data!B$1:B$23,MATCH($A$2,OFFSE T(Data!$A$1,MATCH($C2,Data!$C$1:$C$23,0),0,COUNT(D ata!$A$1:$A$23)+1-MATCH(B2,Data!B$1:B$23,0),1)ata!$A$23,0)+MATCH($ C2,Data!$C$1:$C$23,0)))

I want to search column G on my master sheet for the teacher's name and if it matches then I want the student name in Column A that is in the same row to populate on my subsheet in column A. I guess then use the OFFSET and COUNT to make it move down the column without populating the same student name twice. Using the MATCH A and MATCH B was sort of working for me, but I don't know how to make the formula work by taking out MATCH C.