Hello gurus,

I have the following code

=VLOOKUP($A4,INDIRECT("'S:\Primary Care\BERKS EAST ES 12-13\Practices\["&Y$2&" - "&Y$1&" FINAL.xls"&"]"&Y$2&"'!$A:$G"),6,FALSE)
The figures are returned okay but only if the spreadsheet is open otherwise "#REF!" when it is closed. How do I return the figures if the workbook is closed? I suspect there might be something wrong with the quote marks but not sure what it might be.

Any help appreciated.