Excel 2010
I have a spreadsheet that has 2 sheets.
Sheet 1 is called PC and Sheet 2 is called Names.
On PC tab column A has a long name example
Project Manager Aaron Gibbs Approved Your Document Upload Request (Request No 1002).eml
My problem is I need to Match the Project Managers name in Column A in PC with that if the list of Project Manager Names from the Names tab.
I tried =VLOOKUP(MID(A3,15,12),Names!$A$1:$B$56,2,TRUE) it brought back information but not the correct data. (the project managers name varies in length.)
Name tab has 3 columns and I need to bring back all three column into PC tab.
I thought about creating another column and putting the words Project Manager in front of the project manger actual names to see if it worked but it did not.
I attached the workbook example.
Bookmarks