I have a sheet that correspond students (Column A) to teachers (Column B).

On another sheet I have a list of items worked on by the students. This
sheet has the student's name in Column A. I would like for it to populate the
teacher's name in Column B.

So on the item sheet, if row 5 was done by student Bob, I want B5 to show
the name on Bob's teacher.

Thanks,