Solved: vlookup filename

[CCkfm2000]

hi all...

i've got the following vlookup, what i'm trying to do is to be able to change the number 29.05 from within a cell i.e A1

this vlookup will look at a different file.

I can change the formula manually.



=vLOOKUP(A4,'[ICE_TRAF 29.05.xls]ICE_TRAF'!$A:$R,4,FALSE)


thanks

[Bob Phillips]

=VLOOKUP(A4,INDIRECT("'[ICE_TRAF " & A1 & ".xls]ICE_TRAF'!$A:$R"),4,FALSE)

but it will not work if the other workbook is closed.

[CCkfm2000]

thanks xld will play with it.