Let's say you're entering your search $ value in cell M1.

In column C you could put a "key" formula to assist with this. In C1 put this formula:

=ABS($M$10-$A1)

Copy that down the whole data set.

Then in N1 you can put this formula to bring back the closest day matching your M1 value:

=IF(M1="", "", INDEX(A:A, MATCH(SMALL(C:C, 1), C:C, 0))