Find most Opportunities by Maximum Number

hi I’m a new member here, and I’m an excel beginner

i just wanna ask how to find this problem, i just wanna lookup data by Serial Number Column to return name Column, but serial number have number in different column ? please help me because this problem was tricky for me
so i just wanna lookup serial number by maximum number to show name

enter image description here

>Solution :

try This

its to return Name by MAX point in column A

=INDEX(C2:C9,MATCH(TRUE,(B2:B9=D2),(MAX(A2:A9))))