<p>4组054交作业</p><p>1.=(J4-$C$4)*LOOKUP(J4,$D$7:$D$15,$E$7:$E$15)-LOOKUP(J4,$D$7:$D$15,$F$7:$F$15)<br/></p><p>2.=IF(MID(G23,3,1)="",LOOKUP(MID(G23,1,1),$B$22:$C$44)&LOOKUP(MID(G23,2,1),$B$22:$C$44),LOOKUP(MID(G23,1,1),$B$22:$C$44)&LOOKUP(MID(G23,2,1),$B$22:$C$44)&LOOKUP(MID(G23,3,1),$B$22:$C$44))<br/></p><p> 3.=INDEX($E$52:$G$67,MATCH($J52,$D$52:$D$67,),MATCH(K$51,$E$51:$G$51,))</p> |