Info from an adjoing cell required

[Legacy 116183]

I have a summary document which pulls the information from twelve monthly worksheets;

This formula

=MAX('Prizes October 2021:Prizes September 2022'!J3:J124,1)

works fine for the maximum number of entrants into an event, but what I want to know is which event it is. That information would be in the cell adjoining.

I know I manually llok up the location of the answer to the formula and then manually type a formula to pull the information from that cell, but is not possible to do it automatically, so that if the answer to the formula is May 2022 J84 as an example, the information from May 2022 i 84 could be pulled into a cell on the summary sheet?

Thanks in advance

 

[Fluff]

Duplicate to: LOCATE THE CELL WITH THE MAXIMUM VALUE

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.