I have spreadsheet 1, like this:

Student Name Semester GPA
David Spring 3.8
David Summer 3.9
David Fall 3.5
David Winter 3.3
Manny Spring 2.1
Manny Summer 2.2
Manny Fall 2.5
Manny Winter 2.8


I have another different spread 2, like this:

StudentName Semester GPA
Manny Summer
David Fall

For the spreadsheet 2, I want to look up the values for GPA using
spreadsheet 1.

Is there a way I can do this excel.

Pls help.