Index match function without array formula for multiple rows.

Hi,

I have an index match function that updates a field in Table One based on whether a value in Table One is within the range of values in two fields in Table Two.
Whilst I have managed to get a working function when I try and copy the formula into the other rows within Table one it pulls out the same value for each row which shouldn't happen.
The function is as follows:
=INDEX(Sheet2!F$3:F$589,MATCH(1,IF(P2>=Sheet2!M$3:M$589,IF(P22<=Sheet2!Q$3:Q$589,1)),0))

I have tried it without the array formula and it returns #N/A

What I want to do is paste the function into cells P3, P4, P5 and at the same time P2 change to the relevant row number. Is this possible with this formula or will I have re-write it?

Any suggestion and help is greatly appreciated.

Mark.

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.

I can't upload the workbook because its data from work, which I cant share. Sorry about this.