I have a pivot table with weekending dates going across the top, and names going down column A. The data of course is in the center. I am trying to pull only the last 8 weeks of data. So I created a sheet that gives me the last 8 weeks of dates on top, and I have the names going down column A. I did this by using my weekending formula across the top then -7 - 14 -21 etc up to 8 weeks. This formula points to a cell with the formula =Today() in it and based on that date, my date cells will have the last 8 weeks in it. Now all I want to do is pull the last 8 weeks of data from my pivot. Which would be best to use INDEX and Match or a Vlookup? I want to lookup the data in my pivot and have it displayed in my table tab.