I think I need match index offset sum, but I have no idea in what sequence.
I have dates in cell F2:S2, Numbers in cells F3:S3, Reference cell is c3.
In cell B3 I need a formula that will add up F3 to U3 until they are greater than cell C3, and then return the corresponding date in cell F2:U2 which ever date is adjacent to the number at the time its total is greater than C3.
I hope this is clear.Book3.xlsx
Bookmarks