Compensation Module.

example.xlsx
Hi Everyone !
I would really appreciate ideas about how to accomplish a certain task.
I have attached a very simple example of what I am trying to achieve.
So we have 2 sheets. a sheet called data and a sheet called results.

the data sheet, includes ID's of employees and what they are measured on - Hours and Accounts Finished.
For example, worker 123 put in 100 hours from the 200 expected and finished 100 accounts from the 200 expected.
The main sheet called Results looks up in a list every ID and displays in a table the compensation the worker got.
Each time you select from the drop list a different ID number it shows the result and the amount of money they got.

I want to be able to draw every worker and display the compensation they got('Results', H11) in the Pay amount column('Data',H3:H11).

Any Suggestions would be appreciated.

Link to the other post:
http://www.mrexcel.com/forum/excel-q...on-module.html

Thanks!