On Tue, 28 Jun 2005 02:40:03 -0700, "Saravan"
wrote:


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


Go to http://xcell05.free.fr/english/.

and download and install Longre's free morefunc.xll add-in. Then use the
INDIRECT.EXT function.


--ron