Hi Everyone,
I've been trying to do a 2 criteria lookup funciton, but to no avail. I've also tried to use an aggregate formula, and Index/match but none worked below is a sample of the data. I'm looking to extract the data to match the Date, which is a data validation list, from the Employee and Shift_time Columns.
Any assistance is greatly apprecaited
Sun 4/21/2013 Sun 4/21/2013 Mon 4/22/2013 Mon 4/22/2013 Tue 4/23/2013 Tue 4/23/2013 Wed 4/24/2013 Wed 4/24/2013 Sun 4/21/2013 EMPLOYEE SHIFT_TIME EMPLOYEE SHIFT_TIME EMPLOYEE SHIFT_TIME EMPLOYEE SHIFT_TIME JON DOE1 03:00-11:30 JOHN DOE 1 03:00-11:30 JANE DOE 1 03:00-11:30 EMPLOYEE SHIFT JON DOE2 03:30-08:30 JON DOE2 03:00-11:30 JOHN DOE 2 03:30-08:30 JANE DOE 2 03:30-08:30 JON DOE3 03:30-08:30 JON DOE3 03:30-08:30 JOHN DOE 3 03:30-12:00 JANE DOE 3 03:30-08:30 JON DOE4 03:30-12:00 JON DOE4 03:30-08:30 JOHN DOE 4 03:30-12:00 JANE DOE 4 03:30-08:30 JON DOE5 03:30-12:00 JON DOE5 03:30-08:30 JOHN DOE 5 03:30-12:00 JANE DOE 5 03:30-08:30 JON DOE6 03:30-12:00 JON DOE6 03:30-12:00 JOHN DOE 6 03:30-12:00 JANE DOE 6 03:30-12:00
Thank you
MZING81
Layout and formatting can be important here. Please post a sample sheet
Bookmarks