Hi. I'm looking to get a formula to calculate an employee's commission. On worksheet1 there is the employee code (Col. B) and amount of commission (Col. H) but employees are listed multiple times with multiple commissions and need it to add all together. On worksheet2 I'm trying to link the employee code (Col. C) with worksheet2 employee code (Col. B). I did a vlookup but it's finding one commission and stopping there.

Example: Worksheet 2
Col. A Col. B Col. H
John Smith 0123456 $5.00
John Smitth 0123456 $10.00


Help!