LOOK UP FORMULA, Data extraction

[MZING81]

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

[Pecoflyer]

Layout and formatting can be important here. Please post a sample sheet