2 issues on excel formula

[kelvin_9]

Greeting everyone, i would like to know how can i use a index+match or others formula to trigger my request as attached
Q1) sheet 1, first i extract initial and last time for everyone, after that i want to map if they meet my request with L1:N1 criteria.

=INDEX($L$1:$N$1,MATCH($K$3:$K$5,$A$2:$I$6,0))

Q2) sheet 2, i have deployed a RDO(Rotation Day Off) to everyone on Q3:Q5, everyone should have maximum 2 days off each week
however i want to easier identify that which one are their RDO with left table, how can i easily track like yellow cell, W3, V4 & U5
i get stuck and i'm not sure if i use "if+index+match" will help or not.
ps. if Q3:Q5 match with column A, R2:X2 match one of the left RDO table, return RDO on one of their blank cell

thanks so much for all your help

http://kel.ddns.net/f/a4c3596705/?raw=1

 

[kelvin_9]

file was updated.
i tried to simplify the RDO table to horizontal, and use=IF(COUNTIF(A:A,J3),"yes","no")
but i stuck in find blank cell on each row and testify this

anyone can help / point me out would be great appreciated
thanks so much!!!