Comparing two columns and finding matching date

[Shawnkm]

I have been at this for quite some time with no luck. I have read through the forums, but still not getting it. Here is what I am trying to accomplish (with a non VBA solution):



Column A is a running total (total invoices), as well as column E (total payments). Column D are dates matching column E.
When column E matches or exceeds column A, return the matching date from column D to column B.

Example: A2 needs $1000 to be paid... so on 1/14/16 (D3) $1000 has been paid to equal $1000 or more. So on A2 is paid in full on 1/14/16.

A3 needs $1600, which was happened on 2/15/16, so B3 is should have the value of D5.

Any help you can give me would be greatly appreciated... feel free to add helping columns or whatever. Thank you so much for your help on this.

 

[Hui]

Shawnkm

Firstly, Welcome to the Chandoo.org Forums

Some quick advice, If you attach a small sample file, it speeds up the process of getting an answer to you remarkably, so then we can move onto others problems, rather than having to setup a set of data to solve your problem

B2: =INDEX($D$2:$D$6,MIN(IF($E$2:$E$6>=A2,ROW($E$2:$E$6)))-1) Ctrl+Shift+enter
Copy the formula down