I have two worksheets. In "OneView" (worksheet 1), I have a column that lists people names and they will appear multiple times for different projects. The person's name will always have a Primary Role listed in another column. The projects that the person has worked on will also have another column that lists the Plan Type associated with the project. (This worksheet has approximately 3033 rows.)

In the other worksheet "TimeSheetData" (Worksheet 2), i have have a column that lists the people's names and the projects that they work on. However, there is no Primary Role nor a Plan Type associated with the project. (This worksheet has approximately 1017 rows)

If possible, I'd like to grab the Primary Role from the OneView worksheet and populate it in a column in the TimeSheetData worksheet for the matching person. And, if possible, I'd also like to grab the Plan Type from the OneView worksheet and populate it in a column in the TimesheetData worksheet for the matching project.

I can't just sort the data in both worksheets and then do a simple IF compare because one worksheet is a week view and the other is a daily view. but in order to use both in power pivot, i need the data in both worksheets.

a sample of the data in the OneView worksheet looks something like this. The data in the TimeSheetData worksheet looks the same minus the Plan Type & Primary Role.
Project Plan Type Resource Primary Role
Mercury - MDM Project S, KAVYA SOA/Automation Eng
Mercury - MDM Project S, KAVYA SOA/Automation Eng
Mercury - MDM Project B, SHREEKANTH SOA/Automation Eng
Mercury - MDM Project B, SHREEKANTH SOA/Automation Eng
SOLMOD Pgm Support V, SHIRIN SOA/Automation Eng
SOLMOD Pgm Support T, SHIVA KUMAR QA Lead
Customer Master Project P, PAVANI SOA/Automation Eng
Customer Master Project P, PAVANI SOA/Automation Eng
Customer Master Project P, PAVANI SOA/Automation Eng
Customer Master Project P, PAVANI SOA/Automation Eng
CCO Enhancement A, CARRIE QA Lead
Platform Upgrade Project T, Praneeth QA Lead
Customer Master Project A, PREETHI Tester
Customer Master Project V, UTTAM SOA/Automation Eng
Customer Master Project V, UTTAM SOA/Automation Eng
Customer Master Project V, UTTAM SOA/Automation Eng
Customer Master Project P, PAVANI SOA/Automation Eng
Mercury - MDM Project R, ANNA QA Lead

The data in the other worksheet would have the same names and projects but it would not have the Primary Role or Plan Type. So, I'm wanting to create those columns based on the data that is in the first worksheet. Is there a way to have a function to that? I appreciate your help! I tried the following: =INDEX(TimeSheetData!$E$1:$E$1000,MATCH(OneView!$L1,TimeSheetData!$M$1:$M$1000,0)) but got a #N/A error. I also switched the worksheet names around but got the same results.