How do I pull info utilizing 2 identifiers in Excel?

Posted on 2014-08-27
Medium Priority
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

Accepted Solution

tomfarrar earned 2000 total points
ID: 40288104
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
ID: 40288116
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

ID: 40288123
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.

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

569 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