根据BOM表计算订单用量,请各位EXCEL高手帮忙,谢谢!答:在H2输入:=G2*CHOOSE(SUM(A2:E2),--SUBSTITUTE(MID($I$1,5,10),RIGHT($I$1,1),""),INDEX(H:H,MATCH(,0/($A$1:$A$21=1)),),INDEX(H:H,MATCH(,0/($B$1:$B$21=2)),),INDEX(H:H,MATCH(,0/($C$1:$C$21=3)),),INDEX(H:H,MATCH(,0/($D$1:$D$21=4)...