vlookup
this should work:
VLOOKUP($C10,INDIRECT(A1&"Sheet1'!$A$2:$F$7500"),2 ,0)
"BrianW" wrote:
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
|