How to select a value in a range using a dropdown.

Hi

Sorry if the title is a bit ambiguous.

What I am trying to do is (please see attached) have a dropdown with rating of 1 to 5, Col C. A Salary is in Col B. When a perfomance rating has been selected, the increage %age must be picked up according to what salary ragnge the salary falls into, Col D.

Hope this makes sense.

Thanks

Regards

Cortlyn

In cell D2

=INDEX($H$2:$L$10,MATCH(B2,$F$2:$F$10,1),6-C2)

and copy down