StillUnderstanding
Board Regular
- Joined
- Jan 30, 2021
- Messages
- 80
- Office Version
- 365
- Platform
- Windows
- MacOS
Hi Everyone,
I have a workbook that has an "index" tab and that pulls the names of the other tabs in the workbook into the page in column A, then in column B I have a "Team Leader".
I have set a range for the titles and for the full sheet.
On the tab called "manage" I have cell E3 that contains the tab name using the following formula "=MID(CELL("filename",E4),FIND("]",CELL("filename",E4))+1,256)"
So on the index tab, cell A2 it now matches what is in cell E3 (The name of the tab) but when I attempt to do a match to bring back the data from the column called "Team Leader" using the below formula it returns 0.
=IFERROR(VLOOKUP($E3,Team_Leader_sheet,MATCH("Team Leader",Team_Leader_titles,0),),)
If I manually type the tab title into cell E3 of the managed tab then it returns the correct result. I think the issue is that a formula is in E3 but I am not sure.
Can anyone help with this please?
I have a workbook that has an "index" tab and that pulls the names of the other tabs in the workbook into the page in column A, then in column B I have a "Team Leader".
I have set a range for the titles and for the full sheet.
On the tab called "manage" I have cell E3 that contains the tab name using the following formula "=MID(CELL("filename",E4),FIND("]",CELL("filename",E4))+1,256)"
So on the index tab, cell A2 it now matches what is in cell E3 (The name of the tab) but when I attempt to do a match to bring back the data from the column called "Team Leader" using the below formula it returns 0.
=IFERROR(VLOOKUP($E3,Team_Leader_sheet,MATCH("Team Leader",Team_Leader_titles,0),),)
If I manually type the tab title into cell E3 of the managed tab then it returns the correct result. I think the issue is that a formula is in E3 but I am not sure.
Can anyone help with this please?