VLookup With Multiple Criteria And Calculations?

I have one spreadsheet that contains employee overtime info per pay period which is bi-weekly, another spread that has their monthly production numbers. So...

Employee OT PayEndDate
John Smith 5 01/13/12
John Smith 7 01/27/12
Jack Jones 8 01/13/12
Jack Jones 9 01/27/12
John Smith 6 02/10/12
John Smith 3 02/24/12
Jack Jones 8 02/10/12
Jack Jones 10 02/24/12
And so on

On the other sheet
Employee Production Month
Jonh Smith 53 Jan
Jack Jones 75 Jan
John Smith 45 Feb
Jack Jones 80 Feb
And so on,

What I need to do is see the overtime hours per month, and the production numbers for the same month. Something like...

Employee OT Production Month
Jonh Smith 12 53 Jan
Jack Jones 17 75 Jan
John Smith 9 45 Feb
Jack Jones 18 80 Feb

I have a pivot table the sums up the OT by PayEnd Date but need to change PayEndDate to month, which I know how to do, but then add in the production any thoughts on how I could do this?