Need result from Column A based on MAXIFS result from Column B

Hello.

I'm having trouble with writing a formula that will give the, for instance, corresponding value in Column A based on the result of a MAXIFS formula that finds the Max value in Column C, if it first matches a Value in Column B.

I've used the below code to find the Max Value in Column C, based on first matching a criteria found in Column B.

=MAXIFS('Sheet 2'!$C$2:$C$202,'Sheet 2'!$B$2:$B$202,'Sheet 1'!E$4)

Yet, if I use OFFSET(MATCH) to try and retrieve the value I need from Column A, it gets tripped up with any duplicates. I've used the following:

=OFFSET('Sheet 2'!$A$1,MATCH(MAXIFS('Sheet 2'!$C$2:$C$202,'Sheet 2'!$B$2:$B$202,'Sheet 1'!E$4),'Sheet 2'!$C$2:$C$202,0),0)

I know the problem is that the code is finding the first instance of the matching value found from the MAXIFS formula, so what I need help with is forcing the formula to find the find the answer in Column C (based on matching a criteria in Column B) and then outputting the value in Column A based on finding what Row the answer to the previous MAXIFS was found in...

My apology for not being able to explain more concisely. I've attached a workbook where i've tried to dumb it down to its simplest parts.

Thanks in advance.