I am trying to use Indirect to return back a scoring value from the table below. When i enter a value into D37, it only returned the closes whole number and not the closest rating.

For example if i entered in 12.80%(no rounding needed) it would return 1.0 and not 1.2



Formula =VLOOKUP(D37,INDIRECT(C2),2)
D37 = Data i want looked up
C2 = Table Name

(Table Below)
Score Rating
1.00% 1.00
6.90% 1.10
12.80% 1.20
18.70% 1.30
24.60% 1.40
30.50% 1.50
36.40% 1.60
42.30% 1.70
48.20% 1.80
54.10% 1.90
60.00% 2.00
61.00% 2.10
62.00% 2.20
63.00% 2.30
64.00% 2.40
65.00% 2.50
66.00% 2.60
67.00% 2.70
68.00% 2.80
69.00% 2.90
70.00% 3.00
71.00% 3.10
72.00% 3.20
73.00% 3.30
74.00% 3.40
75.00% 3.50
76.00% 3.60
77.00% 3.70
78.00% 3.80
79.00% 3.90
80.00% 4.00


Thanks in advance for any help, if i can nail this down my project will be just about done!