I have a pretty simple problem. I want to assign packages to my customers based on the revenue and the size. I am attaching here the sample of problem. The sample of data on revenue is in the tab 'Revenue' and the data on how to decide the package is in the tab 'Package Decision'.
Given the size of the customer, I want to look in the tab of 'Package decision', match the size of the customer with the size given in the 'package decision' and then look up for the revenue, and then assign the package.
So if the customer is in size 1 and has a revenue of 300, then he should be assigned 'Standard' Package and not any other package. If the revenue is 2200 then he should be assigned Platinum. If it is 200 then 'Basic'.
It should be pretty simple, but I think I am unable to find out how to do it.
Thanks in Advance