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!!
Bookmarks