Point at which a range of cells equals specified value

[allemanable]

I have data that shows the amount of earnings earned each quarter by customer on sheet 1

Customer	Quarter	Quarterly Earnings
1234	1Q16	$5.00
1234	2Q16	$10.00
1234	3Q16	$15.00
5678	1Q16	$5.00

<tbody>
</tbody>

On sheet 2, data shows

Customer	Earnings Due	Quarters To Be Paid
1234	$25.00	??
5678	$5.00	??

<tbody>
</tbody>

I am trying to find a formula/macro that will look up customer 1234, find the point at which earnings = $25.00 and bring back the quarter at which point this happens (2Q16). Any suggestions??

 

[jarjarbingie]

I have data that shows the amount of earnings earned each quarter by customer on sheet 1

Customer	Quarter	Quarterly Earnings
1234	1Q16	$5.00
1234	2Q16	$10.00
1234	3Q16	$15.00
5678	1Q16	$5.00

<tbody>
</tbody>

On sheet 2, data shows

Customer	Earnings Due	Quarters To Be Paid
1234	$25.00	??
5678	$5.00	??

<tbody>
</tbody>

I am trying to find a formula/macro that will look up customer 1234, find the point at which earnings = $25.00 and bring back the quarter at which point this happens (2Q16). Any suggestions??

Sheet1:

D2=SUMIF($A$2:A2,A2,$C$2:C2) drag down


Sheet2:

C2=INDEX(Sheet1!$B$2:$B$5,MATCH($A2,Sheet1!$A$2:$A$5,0)+MATCH($B2,OFFSET(Sheet1!$D$1,MATCH($A2,Sheet1!$A$2:$A$5,0),0,COUNTIF(Sheet1!$A$2:$A$5,$A2),1),1)-1)