I2=LOOKUP(1,0/(LEFT(B$2:B$5,FIND("-",B$2:B$5)-1)-LEFT(G2,FIND("-",G2)-1)<=0)/(A$2:A$5=F2),C$2:C$5)
J2{=VLOOKUP(F2&1,IF({1,0},A$2:A$5&(LEFT(B$2:B$5,FIND("-",B$2:B$5)-1)-LEFT(G2,FIND("-",G2)-1)<=0)*(MID(B$2:B$5,FIND("-",B$2:B$5)+1,9)-MID(G2,FIND("-",G2)+1,9)>=0),C$2:C$5),2,)
留言
張貼留言