How do I pull info utilizing 2 identifiers in Excel?

Posted on 2014-08-27
Last Modified: 2014-08-27
I am trying create a pivot table from 2 different sets of data in excel.  I need to pull all the info from one set and then add the hours/day from another set based off of the date/Employee ID.  Similar to creating a query in Access from 2 different tables.  


I could add a column to the first that references the second set.  Is it possible to do a VLOOKUP where it has to match both Date(column A) and Employee ID(column D) to pull Hours Worked(column C)?

Don't need a Macro just a one time GUI solution.
Question by:garyrobbins
    LVL 7

    Accepted Solution

    You could concatenate the two fields on both files and then do a VLookUp based on the concatenation.  Make sense?
    LVL 27

    Expert Comment

    by:Glenn Ray
    Without seeing the actual data, it's hard to say, but sounds like a SUMIFS function will work in this case also.

    Can you at least describe the key data in the two tables?  Your second paragraph seems to only mention one table with three specific columns.


    Author Closing Comment

    Yeah, I actually do that already on another report, don't know why I didn't think of it.  I'm always trying to make things harder than they need to be.  Thank you for the quick reply.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    761 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

    14 Experts available now in Live!

    Get 1:1 Help Now