ExcelBanter - vlookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - vlookup (https://www.excelbanter.com/excel-worksheet-functions/121704-vlookup.html)

brianw

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

Eddie O

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

brianw

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

All times are GMT +1. The time now is 03:23 PM.