[SOLVED] How to select a value in a range using a dropdown.

Cortlyn · #1 07-03-2009, 07:10 AM

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

sweep · #2 07-03-2009, 07:51 AM

In cell D2

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

and copy down

Cortlyn · #3 07-03-2009, 07:58 AM

Thank you very much.

Kind regards

Cortlyn

Welcome to the Excel Forum

Forum Statistics