M
mario
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.
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.