The attached spreadsheet has a detail section and a summary section.
Summary is from Column J to W
Detail section is from Column AG to GA
The columns are static and will not change.
Cell C2 has the Key Date.
I am trying to figure out a way that when the user changes the date in C2, the detail section would change the HLOOKUP so that the dates and values would align so the key date would be in the current week range (Columns Q to W) and previous week would be in Columns J to P.