looking for adjustment to return data from adjacent cell

[ZBEER]

Hello Excel Forum,

I would like to get a bit of an adjustment to the attached file. Retrieving student number would be the task, based on their marks. I could get to, finding match, but would like to retrieve student number. Tried helper column, but beside matching the marks, could not figure out how to retrieve data from the student number's cell.
Researched online, but could not match and adjust formulas to fit my need.
Thank you in advance!

[Pete_UK]

You could use this in J6:

=SUMIFS(E:E,A:A,J2,B:B,J3,C:C,J4,D:D,J5)

Hope this helps.

Pete