I want to find out the hourly rates of employees by looking up at their skills and experiences.I have a separate dataset in which all the data of the employees in present. I would look at the experience and skill in this data and I have another table in which rates are mentioned according to skills and experience ranges like 0-2,2-4 and so on.
Below is a sample Rate table and i wnt to apply lookup on my another table :-
Skill 0-2 2-5 5-8
android 200 300 400
Name Email Exp Project Rate