Excel function to return tab name

  • Thread starter Thread starter masoud12345
  • Start date Start date
M

masoud12345

I have a spreasheet with multiple tabs. I am getting the maximum valu
of a table in a summary tab. The table is present in each tab wit
different values. I would like to know if there is a way to know fro
which tab that maximum value came from. (since the table is present i
tab1, tabb2 , tab3 for example and the max comes from tab3, how can
know without going through each tab myself, from which tab the valu
came from?).
Thanks for your help
 
I would use a helper table on a separate worksheet.

I'd put the names of the worksheets in column A and formulas like this in column
B:

=max(tab1!a1:z99)

Then I'd use a formula like this to get the name:

=index(a:a,match(max(b:b),b:b,0))

(say in C1 of that same helper sheet)
 
Back
Top