Index Match with Multiple Criteria.

[hajiali]

RSS Exception Log Layout.xlsm
	C					H	I
2	LAST					TUESDAY	POS
3	BILL					05:30-14:00	Z4
4	TOM					13:45-22:15	Z4
5	WILL					13:00-21:30	E1
6	MARK					OFF
7	JAMES					OFF
8	DAVID					13:00-21:30	Z2
9	ROBERT					05:00-13:30	E3
10	MATT					OFF
11	LORA					04:15-12:45	E2
12	SARA					16:30-01:00	C1
13	JENN					OFF
14	KATE					12:30-21:00	T1
15	JENNIFER					OFF
16	MIKE					04:15-12:45	Z1
17	PETER					04:15-12:45	T1
18	DAVID					12:30-21:00	Z1
19	TOMAS					13:00-21:30	Z3
20	JUSTIN					08:00-16:30	AD
21	LISA					16:30-01:00	C1
22	DAWOOD					05:00-13:30	Z2
23	HAMZA					05:00-13:30	E1
24	HAJI					05:00-13:30	Z3
25	ALI					OFF
RSS BID

using the Table above im tring to pull names of all AM start times to the am column. in the example below its Pulling KATE because its the first T1 that it come to in the above table. I need it to pull the agent that has T1 and is a AM start time. so instead of KATE it should be PETER. An AM start time is < time(11,0,0). I ok using helper formulas or other methods. any suggestion is greatly appreciated

RSS Exception Log Layout.xlsm
	T	U	V		X	Y
3	AM	Schedule	POS		Schedule	PM
4	KATE	12:30-21:00	T1
5	MIKE	04:15-12:45	Z1
6	DAVID	13:00-21:30	Z2
7	TOMAS	13:00-21:30	Z3
8	BILL	05:30-14:00	Z4
9			Z5
10	WILL	13:00-21:30	E1
11	JUSTIN	08:00-16:30	AD
RSS LOGS

Cell Formulas
Range	Formula
T4:T11	T4	=IFERROR(IF($L$1=TRUE,INDEX('RSS BID'!$C$3:$Q$25,IF($O$1="SUNDAY",MATCH(V4,'RSS BID'!$E$3:$E$102,0),IF($O$1="MONDAY",MATCH(V4,'RSS BID'!$G$3:$G$102,0),IF($O$1="TUESDAY",MATCH(V4,'RSS BID'!$I$3:$I$102,0),IF($O$1="WEDNESDAY",MATCH(V4,'RSS BID'!$K$3:$K$102,0),IF($O$1="THURSDAY",MATCH(V4,'RSS BID'!$M$3:$M$102,0),IF($O$1="FRIDAY",MATCH(V4,'RSS BID'!$O$3:$O$102,0),IF($O$1="SATURDAY",MATCH(V4,'RSS BID'!$Q$3:$Q$102,0)))))))),1)),"")
U4:U11	U4	=IFERROR(IF($L$1=TRUE,INDEX('RSS BID'!$C$3:$Q$25,IF($O$1="SUNDAY",MATCH(V4,'RSS BID'!$E$3:$E$102,0),IF($O$1="MONDAY",MATCH(V4,'RSS BID'!$G$3:$G$102,0),IF($O$1="TUESDAY",MATCH(V4,'RSS BID'!$I$3:$I$102,0),IF($O$1="WEDNESDAY",MATCH(V4,'RSS BID'!$K$3:$K$102,0),IF($O$1="THURSDAY",MATCH(V4,'RSS BID'!$M$3:$M$102,0),IF($O$1="FRIDAY",MATCH(V4,'RSS BID'!$O$3:$O$102,0),IF($O$1="SATURDAY",MATCH(V4,'RSS BID'!$Q$3:$Q$102,0)))))))),$P$3)),"")