I am using VLOOKUP to populate a table in Excel. The formula is identical from row to row, except the file in which data is being referred to is changing by one character.
For example, cell B1 says:
=VLOOKUP($A$1,'N:\August\[08-05-2018.xlsx]Assembly Throughput'!$A$3:$O$64,B35,FALSE)
Cell B2 says:
=VLOOKUP($A$1,'N:\August\[08-06-2018.xlsx]Assembly Throughput'!$A$3:$O$64,B35,FALSE)
I would like to autofill the rest of the rows so that cell B3 refers to the file "08-06-2018.xlsx", cell B4 refers to the file "08-07-2018.xlsx", etc, but I don't know how to automatically increment these numbers, considering they are the title of a file. Is this possible? If not, is there another way to populate this table without manually inputting the file names?
Bookmarks