Originally the formula was:
=VLOOKUP(A3,'I:\Fld\[Fil 01 01 06.xls]Pricing'!$A$1:$D$30,4,FALSE)
But the date in the file name can change regularly and there are loads
of formula like the above, so I thought to be able to change a date in
single cell C1 and the formulas to dynamically change would be good.
I've tried the 2 below formula without any success:
1.=VLOOKUP(A3,'I:\Fld\[Fil " & C1 &".xls]Pricing'!$A$1:$D$30,4,FALSE)
2.=VLOOKUP(A3,'I:\Fld\[Fil " & INDIRECT(C1)
&".xls]Pricing'!$A$1:$D$30,4,FALSE)
Any one got any ideas??
Help greatly appreciated.
Jason
Bookmarks