Index aggregate formula help

Hi

I have been trying to get this formula right, but everything I've tried so far is coming up short!

What I'm trying to do is bring a summary of details from the scoresheet, across to the results sheet, by finding the max value in the points column (on the Scoresheet), and transfer the member and species associated to that value into the correct row on the 'Results' sheet.

The closest I have come so far is: =IFERROR(INDEX(Jan2021!$c$3:$c$200,AGGREGATE(15,3,((Jan2021!$a$3:$a$200=$b11)/(Jan2021!$a$3:$a$200=$b11)*ROW(Jan2021!$a$3:$a$200))-ROW(Jan2021!$a$2), ROWS($a11:a11))),””)

The yellow section on the results summary is the only area pulling the results from the Jan2021 scoresheet.

The date in B1 of Results will become a dropdown, directing to a corresponding month of Scoresheets (I have only provided Jan2021 on the example).

Thankyou in advance for any help!!

Perhaps like this?

C3 and down:
=INDEX('Jan2021'!$D$1:$D$7,MOD(AGGREGATE(14,6,((B3='Jan2021'!$B$3:$B$7)*((ROW('Jan2021'!$D$3:$D$7)/1000)+('Jan2021'!$E$3:$E$7))),1),1)*1000)

D3 and down:
=INDEX('Jan2021'!$C$1:$C$7,MOD(AGGREGATE(14,6,((B3='Jan2021'!$B$3:$B$7)*((ROW('Jan2021'!$D$3:$D$7)/1000)+('Jan2021'!$E$3:$E$7))),1),1)*1000)

Sorry about that!

I've attached an amended copy with a little more data....specifically the formula which is almost working, but not quite.

It brings back the first match result, not determined by the max value/points

Thanks

Originally Posted by belinda200

Perhaps like this?

C3 and down:
=INDEX('Jan2021'!$D$1:$D$7,MOD(AGGREGATE(14,6,((B3='Jan2021'!$B$3:$B$7)*((ROW('Jan2021'!$D$3:$D$7)/1000)+('Jan2021'!$E$3:$E$7))),1),1)*1000)

D3 and down:
=INDEX('Jan2021'!$C$1:$C$7,MOD(AGGREGATE(14,6,((B3='Jan2021'!$B$3:$B$7)*((ROW('Jan2021'!$D$3:$D$7)/1000)+('Jan2021'!$E$3:$E$7))),1),1)*1000)

Thank you Belinda!
Unfortunately it gives similar results to my second attachment - bringing the first match, where I am looking for the max of each category.

Thank you so much Belinda and Glenn!!
I am extremely grateful

I completely agree with you Glenn about the monthly scoresheets being consolidated to one sheet, however I'm doing this as a favor for my elderly father, and when I showed a consolidated option it was a little too hectic for him. He needed a single scoresheet per month, so that's what I'll do while I quietly nudge him in the consolidated sheet option.

Thank you again guys!!

Thanks for the feedback frencett, and you're welcome.
if you are satisfied with the solution - you can mark this thread as solved.