Link
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><bdo dir="ltr">=INDEX(Student,MATCH("Teacher 2",Teacher,0))
<bdo dir="ltr">=IF($A$2=INDEX(Student,MATCH("Teacher 2",Teacher,0)),OFFSET(INDEX(Student,MATCH("Teacher...