C31单元格输入公式=IF($B31="","",IF($A31="1级",INDEX($F$2:$F$4,MATCH(LOOKUP($B31,{-100,0.03,0.04},{0,3,4})/100,$D$2:$D$4,)),IF($A31="2级",INDEX($F$5:$F$7,MATCH(LOOKUP($B31,{-100,0.027,0.03},{0,2.7,3})/100,$D$5:$D$7,)),IF($A31="3级",INDEX($F$8:$F$10,MATCH(LOOKUP($B31,{-100,0.024,0.028},{0,2.4,2.8})/100,$D$8:$D$10,)),""))))
下拉公式。 如图:
示例
Excel怎么进行多条件查找?这个视频告诉你!