Hello Tim,

Are you sure that you use the suggested formula?

I used
=INDEX(D1:D50,MATCH(MIN(ABS(C1:C50-A1)),ABS(C1:C50-A1),))
(as array formula!) and it worked.

Regards,
Volker