Jbeaucaire,

Thanks that works great. Do you think this would be the best way to make any 0's blank in the results or is there something better?
=IF(IF(ROW(G4)>$C$2, "", INDEX('Student Roster'!G:G, MATCH(ROW(G4), 'Student Roster'!$K:$K, 0)))=0,"",IF(ROW(G4)>$C$2, "", INDEX('Student Roster'!G:G, MATCH(ROW(G4), 'Student Roster'!$K:$K, 0))))

Thanks again for your help