Date search

[elewis1220]

Hello All,

I am currently trying to figure out a formula. I have attached an excel document as well as input some values in this message for visual assistance (the real report contains lots of data). I need to be able to display the date for which the transaction amount was repaid after the NSF (negative dollar amount). I tried a vlookup to search based upon ID# but it only returns the first date which is the initial payment.


ID # Transaction Date
15555 $500.00 12/2/2013
25555 $87.59 12/2/2013
35555 $100.00 12/3/2013
45555 $900.00 12/4/2013
55555 $100.00 12/4/2013
65555 $48.00 12/5/2013
55555 ($100.00) 12/5/2013
15555 ($500.00) 12/5/2013
75555 $63.00 12/6/2013
16666 $129.00 12/6/2013
26666 $38.00 12/6/2013
36666 $114.00 12/6/2013
55555 $100.00 12/7/2013
15555 $500.00 12/7/2013