vlookup match between a tab name and index to bring back a result

StillUnderstanding

New Member
Joined
Jan 30, 2021
Messages
37
Office Version
  1. 365
Platform
  1. Windows
  2. 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?
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

StillUnderstanding

New Member
Joined
Jan 30, 2021
Messages
37
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Just worked it out, the issue is with it being a date value and so I used this code:- =DATEVALUE(MID(CELL("filename",E3),FIND("]",CELL("filename",E4))+1,256))
 
Solution

Watch MrExcel Video

Forum statistics

Threads
1,127,884
Messages
5,627,465
Members
416,249
Latest member
yogaraj IND

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top