Excel: How to pull data on different sheets

Posted on 2011-04-21
Last Modified: 2012-08-14

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.
Question by:Maliki Hassani
    LVL 30

    Accepted Solution

    Is this What you want?


    Author Closing Comment

    by:Maliki Hassani
    Thanks Sid

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now