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!

In cell F3, use:

Formula:

=($B3/$C3*Results!$D$9+$D3/$E3*Results!$D$10)*Results!$B$7

and copy down.

How can we help if we don't know the criteria, to construct a formula?!

Originally Posted by Vadimchik

Im looking for a way to draw the result directly from the result shown for every ID and display everyone in the Data sheet.
The problem is because you can't really construct a formula to do so.. there are a lot of parameters...

If it can be calculated by a formula in the results sheet, it can be calculated by a formula in the data sheet. We can't help unless you show us the actual parameters being used.