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))
Bookmarks