If you can use sheet names like in your example with the same text string
then just different index number it isn't that hard

="Sheet"&MATCH(MAX(Sheet1:Sheet8!C1),N(INDIRECT("' Sheet"&ROW(INDIRECT("1:8"))&"'!C1")),0)

entered with ctrl + shift & enter will return the sheet name that holds the
MAX value, note that if there are multiple max values the first occurrence
will be returned. That should answer your second question


--


Regards,


Peo Sjoblom




"PKK" wrote in message
...
I'm trying to write a function that returns the worksheet name of a max
value
in a simple 3d reference.

Sheets 1 through 8 hold values in cell C1. In a summary page
=MAX(Sheet1:Sheet8!C1) returns the max value found in any of those cells.
Can a function return the sheet name of the sheet on which that max value
was
found?

Additionally, what errors might be generated if the Max value is on more
than one sheet?

Thank you!