I have attached a spreadsheet that shows start and stop dates for certain volume targets (column I) by customer number (column A). Some records are only one month total, others are many.
I need to take this information and condense it down to ~500 records starting in column M, that shows the customer volume for each month. so for the first record on row 2, I need a formula that says to vlookup M2, then if the records in A2 through I14,000 has a date between columns F & G, then take the volume amount from column I and display. Not sure if you can combine a VLOOKUP and a date between function, but that is what I'm trying to accomplish. Thanks in advance. Book2.xlsx