Formula to calculate a rate based on every 1,000 of payroll

Hello,

I am trying to factor in a column into the attached spreadsheet that will multiply an expense rate/$1,000 of wages. Here is what the table I am referencing looks like......

Age Band Rate/$1,000

Through 29 $.14

30-39 $.18

40-44 $.34

45-49 $..50

50-54 $.78

55-59 $1.46

60-64 $2.24

65-69 $3.78

70 and over $5.81

I do not think I will necessarily worry about inputing their birthdates into a column. I'll look up their bdays and make a rate column out by there name. So, my questions are the following:

1. Is there a way a formula can look up an employee with their corresponding rate, and know to multiply that rate by every $1,000 of wages earned (column H)?