Forum Discussion

Copper Contributor

Sep 25, 2017

closest number

I want to find the closest Liab to the target Liab from the liability list. But don't know how it is done.

Diamond Contributor

Sep 26, 2017

Hi Dennis,

Please update your formula as

=INDEX(B2:$B$100,MATCH(MIN(ABS(C2-B2:B100)),ABS(C2-$B$2:$B$100),0))

and it shall be array formula (Ctrl+Shift+Enter)