Thread: vlookup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eddie O Eddie O is offline
external usenet poster
 
Posts: 18
Default 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