Excel and formulas?? Which one??

I have several columns of data. I not sure if VLOOKUP is the right formula.... but i want to find a student ID number in first column, then a subject in a row(student has several subjects, all subje...