How do I find highest value based on a +/- criteria in another column?

Occasional Visitor

I am trying to improve the formula below which is returning an exact or nearest match in Column 'J' and return the value in Column 'N' in to an adjacent cell (in this case Column 'S') 

=INDEX(N8168:N8171,MATCH(MIN(ABS(J8168:J8171-$J$8132)),ABS(J8168:J8171-$J$8132),0))

What I want to do is return the highest value in 'N' based upon a +/- criteria of Column 'J' rather than the nearest match. Any help would be appreciated.

0 Replies