sheet2A列输入业务员的名字B列输入业务员的提成比例sheet1的提成金额C2=if(a2="","",b2*vlookup(a2,sheet2!a:b,2,0))下拉
A1销售额，A2提成比例，A3提成金额=A1*A2
