I need the rating bonus through the use of vlookup and the raise with an IF statement

2 3 Inputs and Constants 4 Today: 5 Years Threshold: 6 High Year Rate: 7 Low Year Rate: 1/30/2016 3.25% 2.00% Rating Employed Score Rating Bonus Current Years 10 Date Hired Salary Raise New Salary 4/1/2004 $ 50,000 7/15/2012$ 75,250 10/31/2008 $ 67,250 9/8/2003 $45,980 3/14/2011 $ 58,750 6/18/201O$61,000 11.83 3.54 7.25 12.39 4.88 5.62 3.5 4.2 2 1.5 4.5 12 13 14 15 16 17 18 19 20 21 Bonus Data Rating BonuS 100 250 500 $1,000 2 23 24 25 4