Range Lookup

Hi Experts,   I have a data in 2 sheets one is fact table and one i am creating for targets for calculating commissions. Below is the example of dataset, would really appreciate if anyone can prov...