Excel: How to pull data on different sheets

Experts,

I have a spreadsheet that has 2 sheets, the main sheet and sheet1 which sheet1 is used for a data dump.  The spreadsheet is of CMS agents and all their info.  Well the issue is that my data dump will show people that worked that day and not ALL the employees.  That is why I created a main sheet that list all employees and will retrieve the data from sheet1 but it will look for the agents name then the value that is needed.

I am thinking that a Vlookup will be necessary.  I created an example spreadsheet that has a main sheet and the sheet1.  Where the main needs to retrieve the data from sheet1.  However, it is important that it looks for the agents name first, then finds what it is looking for, then the value, since the agent names will be collected randomly.

Any help would be much appreciated.
Thanks
Agent-Data-EXAMPLE.xlsm
Maliki HassaniAsked:
Who is Participating?
 
SiddharthRoutConnect With a Mentor Commented:
Is this What you want?

Sid
Agent-Data-EXAMPLE.xlsm
0
 
Maliki HassaniAuthor Commented:
Thanks Sid
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.