Forum Discussion
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.
1 Reply
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)
