Forum Discussion
MWDB1959
Aug 30, 2022Copper Contributor
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