On Sheet1, Name in Column A, Semester in Column B, GPA in Column C.

On Sheet2, *same* configuration!

Try this is C2 of Sheet2:

=SUMPRODUCT((Sheet1!A$2:A$9=A2)*(Sheet1!B$2:B$9=B2 )*Sheet1!C$2:C$9)

And copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"mario" wrote in message
...
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.