I want to lookup the closest amount (+ or -) in column A based on the numbers in column B. See example below. Any suggestions?
Please Login or Register to view this content.
I want to lookup the closest amount (+ or -) in column A based on the numbers in column B. See example below. Any suggestions?
Please Login or Register to view this content.
Last edited by mkvassh; 07-06-2010 at 07:03 AM.
I found an answer on my own. See below.
=INDEX($B$2:$B$26;MATCH(MIN(ABS($B$2:$B$26-D2));ABS($B$2:$B$26-D2);0))
This is an array formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks