Strugglestreet
New Member
Hello all,
I can't seem to get this to work. I have multiple worksheets in a workbook and i need a formula that I can use to search the rest of the workbook and return the sheet name in the cell. For example i have a lot of seperate sectors within the stock market that are found on multiple indexes. I need a cell in the sector worksheets to search the worksheets that contain the indexes. If the stock code is found then I need to add that index (sheet name) to the stock code. I found a previous post with this formula
=INDEX(Sheet_List,MATCH(1,--(COUNTIF(INDIRECT("'"&Sheet_List&"'!$B$1:$B$400"),Employee_Name)>0),0))
However i am a novice at excel and it keeps returning #name?.
Is someone able to help me solve this please?
Thanks
I can't seem to get this to work. I have multiple worksheets in a workbook and i need a formula that I can use to search the rest of the workbook and return the sheet name in the cell. For example i have a lot of seperate sectors within the stock market that are found on multiple indexes. I need a cell in the sector worksheets to search the worksheets that contain the indexes. If the stock code is found then I need to add that index (sheet name) to the stock code. I found a previous post with this formula
=INDEX(Sheet_List,MATCH(1,--(COUNTIF(INDIRECT("'"&Sheet_List&"'!$B$1:$B$400"),Employee_Name)>0),0))
However i am a novice at excel and it keeps returning #name?.
Is someone able to help me solve this please?
Thanks