How to update the value based on a range in the another table or variable?
Given two files,where sales data contains the details of the sales according to ID or month.
Commission data gives the commission percentages according to ranges.
Now my problem is,When I select a month field in the sheet,if they are more than one sales in that month,two fields get select in the commission percentage if they belong to different ranges.
What I need is instead of that,depending the select values in the sales field,it should calculate the total costs of the sales and check the range and highlight the commission matrix the corresponding percentage.