Column lookup by text

Hey guys,

I'm working with a pivot table with many different names in the leftmost column. "Grand Total" is one of the columns and I want to do a vlookup so it will look up the name in the left most column and find the column that says "Grand Total," and return to me the value in that respective column.

Reason for me wanting to do this is that I want to be able to choose multiple weeks based on the month of data I want to analyze so the column number that "Grand Total" is actually under will change constantly.

Thanks!