輔助 A3:A16=LOOKUP("嫻",B$3:B3)&LOOKUP("嫻",C$3:C3)&E3
L3=VLOOKUP(I3&J3&K3,A:F,6,)
無輔助 L3=LOOKUP(1,0/(I3&J3&K3=LOOKUP(ROW($2:$16),ROW($2:$16)/(B$3:B$16<>""),B$3:B$16)&LOOKUP(ROW($2:$16),ROW($2:$16)/(C$3:C$16<>""),C$3:C$16)&E$3:E$16),F$3:F$16)
另解=VLOOKUP(K3,OFFSET(E$1:F$1,MATCH(J3,OFFSET(C$1,MATCH(I3,B:B,)-1,,19),)+MATCH(I3,B:B,)-2,,19),2,)
留言
張貼留言