I have a spreadsheet that takes data from the other 52 spreadsheets and totals it.
The columns in the sheet correspond to the names of the other spreadsheets (using dates, i.e., 01/01/2017 column contains data from 01012017 spreadsheet). If I change the column names to match the spreadsheet names, how do I use them in the VLOOKUP, so I can just copy my formulas and not have to update the formula in each column?
My VLOOKUP formula is this: =IFERROR(VLOOKUP($A2,'12302016'!$A$7:$I$22,9,FALSE),0)
How do I change the '12302016' to use the column name?
I know that I cannot put 12/30/2016 as my spreadsheet name.