Not really, as I assume that Test01042006 will be closed, and the usual
method uses INDIRECT, which does not work with closed workbooks. In this
case you would use

=VLOOKUP(A1,INDIRECT("'C:\["&A1&"]Sheet1'!$A:$B",2,0)

but there is a solution at
http://makeashorterlink.com/?F2993260A


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ingleg" wrote in
message ...

Hi

I am compiling a spreadsheet that is a series of vlookup columns.

My formula is similar to:

=VLOOKUP(A1,'C:\[Test31032006.xls]Sheet1'!$A:$B,2,0)

Where 31032006 in the file name is the date looked at.

Is it possible to change the formula, to look at a cell reference, and
make it look at the correct file, eg Test01042006.xls?

Thanks in advance.


--
ingleg
------------------------------------------------------------------------
ingleg's Profile:
http://www.excelforum.com/member.php...o&userid=33037
View this thread: http://www.excelforum.com/showthread...hreadid=528538