praveenvelath
New Member
Dear Chandoo,
First of all, thanks a ton for creating this forum (which I came across only last week)! Sharing knowledge is probably the most selfless thing someone could do in this age and time.
I have an issue with SHEETNAME() and would like to know if anyone could help me on this. I have a particular text value in a multi-sheet file, where all sheets have different names. I would like to know if there is a way I can return the names of these sheets where the particular text value is located.
To illustrate, I have a text 'John' in Sheet 1 and Sheet 3. I have a last sheet named 'Consolidated list' which should return the answer for John as Sheet 1, Sheet 3.
Is there a formula based solution for this in Excel? Any help would be appreciated.
First of all, thanks a ton for creating this forum (which I came across only last week)! Sharing knowledge is probably the most selfless thing someone could do in this age and time.
I have an issue with SHEETNAME() and would like to know if anyone could help me on this. I have a particular text value in a multi-sheet file, where all sheets have different names. I would like to know if there is a way I can return the names of these sheets where the particular text value is located.
To illustrate, I have a text 'John' in Sheet 1 and Sheet 3. I have a last sheet named 'Consolidated list' which should return the answer for John as Sheet 1, Sheet 3.
Is there a formula based solution for this in Excel? Any help would be appreciated.