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.
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
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.
VBA Code:
=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