Hello Jacob,

There could be more than one with the max value in sheet1, I think.

I suggest to array-enter into Sheet2!C2:
=MAX((Sheet1!$A$2:$A$100=A2)*Sheet1!$B$2:$B$100))
then copy down...

Regards,
Bernd