Hi,
Can anyone help me with my formula.

VLOOKUP($C10,'C:\TQL\[PRICEWG.xls]Sheet1'!$A$2:$F$7500,2,0)

I want to be able to change the file name [PRICEWG.xls] by a value in cell
A1. such as PriceWG-2006.

T.I.V

BrianW