購買起止日與打折起止日 交叉項目 (13047)

F3:K7=IF(SUM(FREQUENCY(ROW(INDIRECT(VLOOKUP($E3,$A$3:$C$7,2,)&":"&VLOOKUP($E3,$A$3:$C$7,3,))),VLOOKUP(F$2,$A$12:$C$17,{2,3},)-{1,0})*{0;1;0}),"V","")