軟體: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兩次來找，不過要加"*"萬用字元

太感謝你 幫我好多忙