Hi everyone, i would like to use a index+match formula to extract when match with my criteria listed below table
=INDEX($H$1:$J$1,MATCH($G$3:$G$5,$A$2:$E$6,0))
thanks so much everyone for your help
=INDEX($H$1:$J$1,MATCH($G$3:$G$5,$A$2:$E$6,0))
SUN | MON | TUE | IC | Recovery | Lead | ||||
Bee | 10:00-19:30 HH - Recvory | 11:30-21:00 HH - Recvory | SUN | MON | TUE | ||||
Brenda | 09:15-09:45 CR | 11:30-21:00 HH - IC | 09:15-09:45 CR | Bee | Recvory | Recvory | |||
09:45-18:45 HH | 09:45-14:00 HH - CART | Brenda | IC | ||||||
14:00-18:45 HH | Jean | Lead | Lead | ||||||
Jean | 10:00-19:30 Lead | 11:30-20:15 Lead |