满足6个条件 (9560)

 

  O2=LOOKUP(1,0/(MMULT((D$2:G$6=K2:N2)+(D$2:G$6=""),{1;1;1;1})=4)/(J2>=IF(B$2:B$6="",J2,B$2:B$6))/(J2<=IF(C$2:C$6="",J2,C$2:C$6)),H$2:H$6)

另解=LOOKUP(,0/(J2>=B$2:B$6)/(J2<=IF(C$2:C$6,C$2:C$6,J2))/(MMULT((D$2:G$6=K2:N2)+(D$2:G$6=""),{1;1;1;1})=4),H$2:H$6)