Lookup formula to match Employee ID & Date and input a value from a separate Excel sheet

Hi,

I have been using an Index Match function to lookup Employee ID's in one sheet and match them to a look up table in order to fill in the Employee's respective department, division, etc. information.

Now I want to do that to fill in hours, only problem is I need to take into account dates because each employee can have multiple rows of the same date due to different time codes.

I want to lookup and match Employee ID & Date so the hours from one sheet can be correctly dumped into a more trued up version of hours that are in another sheet.

Any help would be greatly appreciated, I attached a sample sheet below. Thank you in Advance!!

Hey can you follow up with that formula, I have tried using other options but still stuck on how to get everything to pull through accurately.

Thats the trouble I'm having. I want to have a formula that will sum all hours for that Employee for that day from the 2nd sheet and input them into the first sheet. I feel like it is some combination of sumifs and index/match.

The premise of this I receive an hours sheet say for April hours in May, but the April hours aren't finalized until June so I receive a true up.

But the one column that will not change is the old FMLA hours column those cannot change ever. But the new report now has 70,000 rows for April hours instead of 50,000 rows so it cant just be a copy and paste them over type of thing, I need to just an index to match the right FMLA hours to that appropriate employee on that specific date.

I tried this before, but the reason it doesn't work if because there's different time codes that can appear for the same day of work. I'm sorry its hard to explain on here because I know you guys get verify the results without really knowing the data. I do appreciate the help and your time.