I want to be able to automatically copy data from a number of different
spreadsheets to a summary spreadsheet on a weekly basis using the VLOOKUP
function. The second parameter to the function, which looks something like
"'[d:\....\file.xls]weekly'!$A$1:$Z$100" has been set up in another cell
within the summary spreadsheet using the CONCATENATE function. How can I
make sure that when I reference this cell within the VLOOKUP call it's
contents are evaluated so that the function correctly refers to the range
within the external file? Currently I am getting a #N/A error