|
|
The
following formula returns a value from B2:B10
that is
closest to the target value in D2...
=INDEX(B2:B10,MATCH(MIN(ABS(B2:B10-D2)),ABS(B2:B10-D2),0))
| Note
that this is an array formula, which needs
to be confirmed with
CONTROL+SHIFT+ENTER for the PC or COMMAND+RETURN for the Mac. |
Based on the sample data, the formula returns 25. Sample
Workbook
|
|
|
