Think INDIRECT can be used but the source file needs to be simultaneously
open for it to work

In say Book2.xls,
Assume the source filename is DV selected in A5, eg: Book1.xls

Provided Book1.xls is simultaneously open
then something like this will work:
=VLOOKUP(C5,INDIRECT("'["&A5&"]Sheet1'!A:B"),2,0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
" wrote:
I have a group of files named sequentially by date. I want to use a dropdown
list to select which file to pull information from. How can I insert the
filename from the dropdown list into a vlookup formula to get the information
from the correct file?