Hi

I wonder if you guys could help me with my issue. I am looking up the largest value across various sheets (1 to 99) with the following formula:

=LARGE('1:99'!$B$1:$B$50;$C3)

That correctly returns the largest value in range B1:B50 across sheets 1 to 99.

However now I want to know the sheet name of the value above in a seperate cell, let say in: A3.
I'm using excel 2010.

Any suggestions?

Thanks a lot!