Looking for a vlookup formula with conditions for a pivot table

[Lisenbe]

I have a tab with employee information on it, with the employee ID starting in C2.
I also have a pivot table (tab name is 12345 PIVOT) created from another tab with information that I want to pull into the employee information sheet.

The pivot contains the employee ID and two types of costs - LABOR and BURDN. Sum of hours worked and the associated amount sum are also depicted here by month (Jan through May).

I want to pull into the employee information sheet the sum of hours worked by month (Jan) by cost type (LABOR).

Thanks!

 

[powerwhatsup]

Filter your pivot table just by cost type ( Labor) and months ( Jan). Drag the month and type in filed to the filter section.

 

[Lisenbe]

Filter your pivot table just by cost type ( Labor) and months ( Jan). Drag the month and type in filed to the filter section.

I have done that. What I then want to do is a lookup to pull that information into columns into my employee information sheet. I can create the lookup that pulls in whatever is filtered on the pivot (=VLOOKUP($C2,'PIVOT'!$A$5:$F$2370,6,FALSE) to pull in just Jan Labor but I also need to pull in Feb, March, April, May and June data for labor into columns and then the same (Jan-May) for burden. So I am looking for a formula to help do that.