软件:office excel
版本:2010
Staff ID Profit Commission
NORD109190 136,319.00 ?
NORD141600 15,708.00 ?
NORD212308 22,321.00 ?
NORD213292 15,477.00 ?
NORD226279 27,321.00 ?
StaffID Salary point
NORD109190 Junior Salesperson
NORD114088 Mechanic
NORD141600 Department Manager
NORD212308 Executive Officer
NORD213292 Department Manager
NORD226279 Senior Salesperson
Position Percentage
JUNIOR SALESPERSONS 2%
SALESPERSONS 5%
SENIOR SALESPERSONS 7%
DEPARTMENT MANAGERS 10%
EXECUTIVE OFFICERS 8%
这有三章表 需要先从第二章表得知是哪个职位 得知职位后从第三表得之佣金的百分比
NORD109190 136,319.00*2%=2726 想过是不是可以用vlookup找两次来找答案
但是好像没办法 请板上高人指点 谢谢!

http://goo.gl/JR6Usp 试试，可用vlookup两次来找，不过要加"*"万用字符

太感谢你 帮我好多忙