I have a time of 12/15/14 12:26PM in cell A1 and the closest matches in my database column(let us say B1:B1000) are 12/15/14 12:25PM and 12/15/14 12:27PM

I have tried using match() with 1 and -1 in ascending and descending order and I can only get it to return 12/15/14 12:27PM but I cannot get it to return 12:25PM. I also need this to be a fast and efficient solution because I need this to be applied to a couple dozen cells every second. I am not sure why I can't get match to work in the opposite direction I am sure I am having some sort of brain freeze.