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
Thank you
MZING81
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