Lookup using 2 criteria
I have 2 Spreadsheets. Employee and Check_IN.
The first (Employees)is a list of employee ids with a column for each workday.
The second (Check_IN) lists each employee id with the date and time they clocked in (Therefore, each employee is listed several times, once for each date checked in).
I want to combine the id and date on each and return the time clocked in on the Employee SS in the relative date column. Of course, if they did not check in, no value would be entered.
I'm attaching a sample of each and would appreciate any help. I've tried several scenarios and can't seem to solve this...would really appreciate any help!!
|