Adding cells until they are greater than a lookup cell and returning a value

[thunderbirdlindy]

I have spent hours on this, and I believe I need a match, offset, index
but not sure which order.

I am trying to total cells until they are greater than the value i
another cell and then pull in the date from an adjacent cell when the
are.

I have dates in E2 to R2
I have numbers in E3 to R3

I have a value in B3

I want to total E3 to R3 until the sum is greater then the value in B3
when it reaches that point, I want to pull the corresponding date fro
cells E2 to R2.
The result needs to be in cell A

 

[Claus Busch]

Hi,

Am Mon, 17 Feb 2014 15:14:34 +0000 schrieb thunderbirdlindy:

I have dates in E2 to R2
I have numbers in E3 to R3

I have a value in B3

I want to total E3 to R3 until the sum is greater then the value in B3,
when it reaches that point, I want to pull the corresponding date from
cells E2 to R2.
The result needs to be in cell A3

if you put your data into columns you can use a formula.
Look here:
https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for the workbook "DateCheck"
With your data in rows you have to solve it with VBA


Regards
Claus B.