3d reference question

[Chuckers]

I have a workbook containing 6 worksheets. Each worksheet name is a persons name however here I'll just use A thru F. To find the lowest value in cell E3 in each worksheet, I use =MIN(A:F!E3) which works just fine. Is there a way to return the worksheet name along with the result such as D160?
Using Excel2003
Thank you very much, Chuck

[Richard Buttrey]

Hi Chuck, and welcome to the forum.

To return the sheet name in a cell you can use:

Please Login or Register  to view this content.

and assuming your example refers to sheet D and the result of your MIN() function is 160, then just concatenate the two. i.e.

Please Login or Register  to view this content.

HTH

[Shijesh Kumar]

here the code

Please Login or Register  to view this content.

[Chuckers]

Thank you both very much for your replies.
Shijesh:
I replaced A:F with the correct worksheet names and entered the formula as both a formula and an array formula however the result that returns is just the word "sheet".

Richard:
I replaced the correct sheet names also but the result that returns is the name of the worksheet that I entered the formula in. (sheet A). the value is correct.

Chuck