合併格 根据月份和星期依表列取值 (9137)

實是星期 G2=IF(F2<>"",TEXT(WEEKDAY(F2,1),"AAAA"),"")

合併格 (單行)A2:C2=VLOOKUP($G2&"：",$I:$M,LOOKUP(9,(FIND("、"&MONTH($F2)&"、","、"&$J4:$M4&"、")>0)*{1,2,3,4})+1+INT(COLUMN(A1)/2),)

實是數字 G2=IF(F2<>"",WEEKDAY(F2,1),"")

合併格 A2:B2右拉C2:D2 下拉=OFFSET($H$5,MOD($G2+5,7),LOOKUP(9,(FIND("、"&MONTH($F2)&"、","、"&$J$4:$M$4&"、")>0)*{1,2,3,4})+1+INT(COLUMN(A1)/2))&""