The formula in F2 should (perhaps) be just =VLOOKUP(E2, $D$14:$E$42, 2)

There must be a value in col D of the lookup table that is less than the smallest value col E, or you'll get an error.

How you combine the values in col D and F to arrive at a final score depends on the relative weight you consider those factors to have.