Hi all,

I have been reading through a couple of threads but cannot seem to wrap my head around adding IF to Index and Matching statements.

What I want to do is to try to create a formula for the following,

1. For all entries for x patient under CURRENT DATA, I want to look up the closest absolute value to 25% (under %max time)
2. Then input the corresponding data in the same row into the cells on the NEW DATA side.

For Example:


file.png



Looking at this, for Patient 2, closest value will be 27%, and the values in the other cells will be 2%, 92, 90 and 1 respectively.

The if, match and index formula that I have always returns a false value.

=IF(A3:A526=H5,(INDEX(C:C,MATCH(MIN(ABS(C:C-N1)),ABS(C:C-N1),0))),1)

This is the formula I have tried. Could anyone help me out with this?

Thank you.

Regards
Matthew