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.