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.