第一题:
1、=VLOOKUP($G9-3500,$B$9:$C$15,2,1)*($G9-3500)-VLOOKUP(VLOOKUP($G9-3500,$B$9:$C$15,2,1),$C$9:$D$15,2,1)
2、=LOOKUP(G16-3500,$B$9:$B$15,$C$9:$C$15)*(G16-3500)-LOOKUP(G16-3500,$B$9:$B$15,$D$9:$D$15)
3、=INDEX($C$9:$C$15,MATCH(G23-3500,$B$9:$B$15),0)*(G23-3500)-INDEX($D$9:$D$15,MATCH(G23-3500,$B$9:$B$15),0)
第二题:
1、=VLOOKUP(G8&H8&I8,IF({1,0},$A$6:$A$15&B$6:B$15&$C$6:$C$15,$D$6:$D$15),2,0)
2、=LOOKUP(1,0/((A6:A15=G12)*(B6:B15=H12)*(C6:C15=I12)),D6:D15)
3、=INDEX(D6:D15,MATCH(G16&H16&I16,A6:A15&B6:B15&C6:C15),0)
第三题:
=INDEX($G$5:$G$7,MATCH($J$5&$K$5,$C$5:$C$7&$B$5:$B$7,0))
第四题:
=VLOOKUP("*"&F6&"*",$A$2:$B$6,2,0)
|