Hi,
I am trying to create a forecasting spreadsheet which looks at previous years data to build a forecast for the month/year.
I am trying to make the lookup cells dynamic according to the date.
For example, May runs from columns DT:EX and Jun runs from EY:GB. So in May, I want the lookups to...