Book1.xls - Cell C3 =
CONCATENATE("'",E:\Saravan\Jun2005,"\[Book2.xls]Sheet1'!$A$4:$B$18")
Book1.xls - Cell A4:A13 have dates (01-jun-2005 to 10-jun-2005)
Book1.xls - Cell B4:B13 should lookup a value corresponding to the date in
Book2.xls

I have tried "=VLOOKUP(A4,INDIRECT(C3),2,FALSE)", Seems to work only with
open work books. Is there any function that could be used on closed workbooks.

Saravan