I'm having some trouble with an excel formula. What I have in sheet A is a list of student names in (Fname LName) format, and then I have the same list of students in a separate sheet along with exam grades in an adjacent column (b). What I'm stuck on is trying to take all of the grades in the second sheet and match them in an adjacent column on the 1st sheet using a formula. The layout is shown below

Sheet A-                     Sheet A-
Names  Grades                Names     Grades
x                            x           1 
x                            x           2
x                            x           3 
x                            x           4
x                            x           5
x                            x           6

Any help is appreciated!

I'm having some trouble with an excel formula. What I have in sheet A is a list of student names in (Fname LName) format, and then I have the same list of students in a separate sheet along with exam grades in an adjacent column (b). What I'm stuck on is trying to take all of the grades in the second sheet and match them in an adjacent column on the 1st sheet using a formula. The layout is shown below

Sheet A-                     Sheet B-
Names  Grades                Names     Grades
x                            x           1 
x                            x           2
x                            x           3 
x                            x           4
x                            x           5
x                            x           6

Any help is appreciated!