L
Legacy 116183
Guest
I have a workbook containg twelve identical worksheets.
I want to locate the cell with the maximum value: Not the value itself, I have that from this: =MAX('Prizes October 2021:Prizes September 2022'!J3:J124,1)
but the address of the cell containing it.
I have tried various combinations of MATCH, VLOOKUP etc without success.
Is there any way of doing that? The answer should be Prizes May 2022 J63.
If I can do that I'd like the information contained in K63 to be available next to the cell reference.
Is it possible?
I want to locate the cell with the maximum value: Not the value itself, I have that from this: =MAX('Prizes October 2021:Prizes September 2022'!J3:J124,1)
but the address of the cell containing it.
I have tried various combinations of MATCH, VLOOKUP etc without success.
Is there any way of doing that? The answer should be Prizes May 2022 J63.
If I can do that I'd like the information contained in K63 to be available next to the cell reference.
Is it possible?