Forum Discussion

MWDB1959's avatar
MWDB1959
Copper Contributor
Aug 30, 2022

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

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.

No RepliesBe the first to reply

Resources