Multiple Condition Lookup and Value Return

[crawdaddy0623]

I have attached a file with 2 worsheets. The first worksheet is my "Master" worsheet. I need to get information off of the "Data" worsheet into the "Master" worksheet. The "Data" worksheet has the following information - employee #, date, and hours worked. I need to be able to assign the hours worked to the Master sheet. I started by wanting to do a vlookup up but it can only handle one condition. I want a formula that can lookup the employee#, then the date, and assign the (hours worked) value next to the date. This information needs to be populated in the "Master" sheet" which already has the employee number and date just in a different format. I would appreciate any help.

Thanks,

[JieJenn]

in E3, enter =SUMPRODUCT(--(Data!$A$2:$A$46=Master!$C3),--(Data!$B$2:$B$46=Master!E$2),Data!$C$2:$C$46) then fill the formula down and across

[crawdaddy0623]

Thank You! Your solution worked perfectly.

[Czeslaw]

Please Login or Register  to view this content.