Hi all,

I am trying to find the next closest date in a set of unsorted data. If the ID in column AD matches, and the name in column J matches, I want to return the next date in the array to the cell in column I. This formula would be in column V, which I’ve filled out with the correct result I want pulled.

I hope this makes sense, I just want to pull the next date given two criteria.

Column I Column J Column V Column AD
1/23/2013 Amp 12/25/2013 2A
9/23/2013 Ben 12/26/2013 3A
8/2/2013 Ben 11/5/2013 2A
12/25/2013 Amp Blank 2A
12/26/2013 Ben Blank 3A
11/5/2013 Ben Blank 2A
1/2/2013 Amp 1/23/2013 2A