Need excel formula to calculate rates using dynamic skills and experience column

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 :-

Table 1

Skill           0-2    2-5     5-8

android    200    300   400

 

Table 2

Name   Email   Exp  Project   Rate

By: tanya

Leave a Reply

Your email address will not be published. Required fields are marked *