Is it possible to have a vlookup reference a cell in the same spreadsheet to determine the name of the outside source the vlookup will be using? Example follows
Instead of:
=vlookup(a1,'C:\Users\[October.xls]Template'!$A:$B,2,FALSE)
I want to use
=vlookup(a1,'C:\Users\["=a2".xls]Template'!$A:$B,2,FALSE)
Where A2 = November?
-Kurt
Bookmarks