Help with possible IF statement

I am trying to set something up in excel. I currently have each class and a list of students taking that exam on separate tabs. I now want to set up a tab where it will give me the exam schedule for that one student. I thought I could set up an IF statement where it would look to see if John Doe was on that first tab, if so give me the name of that class. But I can’t get the statement right. Any ideas?