Returning the Sheet Name using =LARGE formula across multiple worksheets

[fishtech]

I have a workbook with multiple sheets. I am using the following formulas to find the 3 largest numbers in a defined cell across each sheet (L12). I need to return the name of the sheet as well. number will change, and I need the sheet name to be variable based on what the formula pulls in. Any ideas?

=LARGE('Sheet 1:Sheet 54'!L12,1)
=LARGE('Sheet 1:Sheet 54'!L12,2)
=LARGE('Sheet 1:Sheet 54'!L12,3)

 

[Gary's Student]

List the sheet names in column B starting with B1
In A1 enter:

=INDIRECT(B1 & "!L12") and copy down

Finally:

=VLOOKUP(LARGE(A:A,1),A:B,2,FALSE)

 

[T. Valko]

I have a workbook with multiple sheets. I am using the following formulas to find the 3 largest numbers in a defined cell across each sheet (L12). I need to return the name of the sheet as well. number will change, and I need the sheet name to be variable based on what the formula pulls in. Any ideas?

=LARGE('Sheet 1:Sheet 54'!L12,1)
=LARGE('Sheet 1:Sheet 54'!L12,2)
=LARGE('Sheet 1:Sheet 54'!L12,3)

Another one...

Let's assume you have those formulas in A1:A3.

Create this defined named expression.

Name: Names
Refers to: =ROW(INDIRECT("1:54"))

Then, enter this array formula** in B1 and copy down to B3:

=INDEX("Sheet "&Names,MATCH(TRUE,COUNTIF(INDIRECT("'Sheet "&Names&"'!L12"),A1)>0,0))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.