We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Excel: How to pull data on different sheets

Medium Priority
379 Views
Last Modified: 2012-08-14
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
Comment
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks Sid
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.