No, that is why I suggested Harlan's UDF.

--
HTH

Bob Phillips

"Saravan" wrote in message
...

Is there a function to replace INDIRECT in microsoft excel to be used in
vlookup.

"Bob Phillips" wrote:

INDIRECT only works with open workbooks. You could try Harlan Grove's
Pull
function, which you can get at ftp://members.aol.com/hrlngrv/pull.zip

--
HTH

Bob Phillips

"Saravan" wrote in message
...

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