In Sheet 2:
A2: Holds name
B2: Holds Semester

C2: =INDEX(GPA,INDEX(MATCH(A2&B2,Student_Name&Semester ,0),0))
copy down as far as you need


"mario" wrote:

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.