| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup
Hi Eddie.
Tried what you suggested but returned #Ref value "Eddie O" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup a Vlookup | Excel Worksheet Functions | |||
| VLOOKUP Problem | Excel Discussion (Misc queries) | |||
| VLOOKUP Limitations | Excel Worksheet Functions | |||
| Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Hybrid Mode
