如题所述
C3公式下拉:
=IF(B3="","",OFFSET(E$2,MATCH(A3,E$3:E$99,),MATCH(B3,F$2:Z$2,)))
或者用这公式也行:
=IF(B3="","",INDEX(E:I,MATCH(A3,E$3:E$99,)+2,MATCH(B3,F$2:Z$2,)+1))