Calculate bonuses for staff

Hi

I am attaching a workbook and there are two worksheets contained.

The first sheet has some staff ID numbers and $ amounts for product sold. This is just an idea - in reality it will be longer and have more staff member's ID noted.

The second sheet is for calculation of the staff bonus. The top two staff members for a month are paid a bonus. At the moment the bonus is 3.5% of the total sold for that staff member, but the total must be over the current amount of $1000. These figures (bonus percentage and amount to exceed) can change so I need to be able to change these as required on sheet 2 and the calculations will work.

Any help or advice appreciated.

Dave.

Thanks for adjusting your title.

In H2, put this formula, then copy down:

=VLOOKUP($G2, Sheet1!$A:$B, 2, 0)

In I2, put this formula, then copy down:

=IF(AND(H2>=$B$2,OR(H2=LARGE($H:$H, {1,2}))), $H2*$B$1, "None")

In H2 and copied down:

=SUMIF(Sheet1!$A:$A, $G2, Sheet1!$B:$B)