Unanswered: Using VLOOKUP to get at another workbook.
So my problem is quite hard to explain, but I'll do my best.
I have a sheet that has dates as column headers. Each date represents a daily report that is produced. At the moment I have a load of VLOOKUPs going off to those daily report sheets to get data for this summary report.
What I'd like to do is make the VLOOKUP more dynamic. Instead of implicitly defining the name of the sheet in the =VLOOKUP prompt, I would like to get the Table_Array part of the VLOOKUP as the contents of the column header.
Ran into this almost same thing myself at one point. The quick and dirty way is to give the files a generic name so you never have to change the text in the formula. Then save a copy in an archive folder as whatever you want. Its the easiest way to avoid changing the formula, but it requires you to save to copies of the file now also. Still faster I think...at least it was for me. I searched for quite some time on a dynamic way to alter formulas...good luck. I would suggest ANYTHING written by John Walkenbach(Mr. Spreadsheet.)
Probably Excel Formulas 2003 would be the best bet.