Vlookup use or not

[Lpowers66]

I have to look up on table a rebate to subtract from salesmen gross sales. For one salesman I have multiple customers buying same items but not all get same rebates. For example customer infiniti naples buys item 01011 with rebate of $5, but customer dodge naples buys item 01011 with rebate $4. So now I computing Nov sales where I list all Nov sales on one worksheet and it to look up rebate from the other worksheet. What formula do you suggest

 

[wardy0601]

I have to look up on table a rebate to subtract from salesmen gross sales. For one salesman I have multiple customers buying same items but not all get same rebates. For example customer infiniti naples buys item 01011 with rebate of $5, but customer dodge naples buys item 01011 with rebate $4. So now I computing Nov sales where I list all Nov sales on one worksheet and it to look up rebate from the other worksheet. What formula do you suggest

That's a pretty simple one. Just set up a table with rebates applicable to each customer and do a lookup formula (vlookup or index/match) to look up rebate to deduct from sales commission