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

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 in another cell and then pull in the date from an adjacent cell when they 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 from cells E2 to R2.
The result needs to be in cell A3

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

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 he
https://skydrive.live.com/#cid=9378A...121822A3%21326
for the workbook "DateCheck"
With your data in rows you have to solve it with VBA


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2