Thread: Looping IF statements?

I am working on a project that involves a file that has over 100k rows in it and from this I have to pull some data. An overview of the layout and what I need from it are as follows:

The file is a series of oil wells that records monthly production of the wells. So for example cells A1 to A24 and the columns next to it would be monthly production over 2 years with each month listed as well. Now in another sheet I have a list of dates that are important and I need to pull information from 3 months before and 3 months after these important dates. I have been trying to figure out a feasible way to do this using an IF statement or vlookup. For an IF statement I think I have figured out what to do except for one thing.

I want to know if it is possible for the false value to repeat the if statement using the row below the starting rows data. I feel like this would also be possible in VBA but I'm not too familiar with how to use it.

Does my question seem clear? Does this seem possible? If anyone has any suggestions they would be much appreciated