I am trying to do a vlookup of a sum within a range. I have a spreadsheet with columns of numbers (dollar values) with a column of dates at the end of the range. I am trying to lookup the cooresponding date when all of the dollars are spent in a given row.
Example:
Column A - Column B - Column C
Row 1 100 - 0 - 6/30/05
Row 2 0 - 100 - 7/31/05
Row 3 150 - 0 - 8/31/05
Row 4 500 - 0 - 9/30/05
Row 5 0 - 250 - 10/31/05
Row 6 0 - 0 - 11/30/05
Totals 750 350
I want to lookup the total of column A (i.e. 750) and return the date in column C in the cooresponding month where the sum of column A matches the total, basically what month are we done spending money (i.e.9/30/05)
Example:
Column A - Column B - Column C
Row 1 100 - 0 - 6/30/05
Row 2 0 - 100 - 7/31/05
Row 3 150 - 0 - 8/31/05
Row 4 500 - 0 - 9/30/05
Row 5 0 - 250 - 10/31/05
Row 6 0 - 0 - 11/30/05
Totals 750 350
I want to lookup the total of column A (i.e. 750) and return the date in column C in the cooresponding month where the sum of column A matches the total, basically what month are we done spending money (i.e.9/30/05)