如题所述
D2公式:
=LOOKUP(1,0/((A5:A999&B5:B999=A2&B2)*(C2>=--(0&LEFT(C5:C999,FIND("-",C5:C999&"-")-1)))),D5:D999)
如果C列的范围是固定4位数字的,公式精简为:
=LOOKUP(1,0/((A5:A999&B5:B999=A2&B2)*(C2&"">=LEFT(C5:C999,4))),D5:D999)