Sure. The tables below are not a copy of the data but it is representative of issue. Colunm 2 in Table 1 should be populated with Colunm 3 of Table 2 if Table 1 Column 1 is within Column 1 and 2 of Table 2.

Whilst 0.48 and 0.49 will have same value in Table 1 Colunm 2 the rest shouldnt however this is what is happening when I use an array formula.

Table one.

Column 1 Column 2
Mileage as decimal Year
0.48
0.49
1.37
1.52
etc

Table two

Column 1 Column 2 Column 3
Start Mileage decimal End Mileage decimal Year
0.25 0.50 2008
0.50 1.00 1989
1.00 1.50 1965
1.50 2.00 2010


I hope what I have provided is enough to clarify my issue.