LAP
New Member
Hi all,
I attempted to ask this in a thread, but it was SOLVED so I am not sure it could be seen.
In this posting--> http://chandoo.org/forum/threads/ho...-return-sheet-names-solved.11464/#post-176293
I found this formula
and it worked with great success, however:
@NARAYANK991 or @Hui , ninja masters from the above thread,
The formula only returns the first instance (sheet) wherein the value appears and I need all of the sheet names wherein the value appears.
Can we re-write the formula to return the name of the 2nd sheet the value/name appears in, the 3rd sheet, the nth sheet name... into separate column cells? Then I can combine those as needed.
I attempted to ask this in a thread, but it was SOLVED so I am not sure it could be seen.
In this posting--> http://chandoo.org/forum/threads/ho...-return-sheet-names-solved.11464/#post-176293
I found this formula
Code:
=INDEX(Sheet_List,MATCH(1,--(COUNTIF(INDIRECT("'"&Sheet_List&"'!$B$1:$B$400"),Employee_Name)>0),0))
@NARAYANK991 or @Hui , ninja masters from the above thread,
The formula only returns the first instance (sheet) wherein the value appears and I need all of the sheet names wherein the value appears.
Can we re-write the formula to return the name of the 2nd sheet the value/name appears in, the 3rd sheet, the nth sheet name... into separate column cells? Then I can combine those as needed.