creating a variable for file names

B

BEAST

I am trying to create a file called x.xls where in x=cell A1
for example if in cell A1 the value is help
then the file name is help.xls
why?
I have a working vlookup formula =VLOOKUP(x.xls!NUM,x.xls!table,2)
this retreives values from a table in document x.xls
I want to put different values for "x" in cell A1
in order to always feed a form that I made from different copies of the
original x file x1,x2,x3 ets
it a toughy :(
thanks for reading
thanks
 
P

papou

Hello
Use INDIRECT in your formula :
=VLOOKUP(INDIRECT(A1 & "!NUM"),INDIRECT(A1 & "!table"),2)

HTH
Cordially
Pascal
 
B

BEAST

thanks papou this works great you're the best!

papou said:
Hello
Use INDIRECT in your formula :
=VLOOKUP(INDIRECT(A1 & "!NUM"),INDIRECT(A1 & "!table"),2)

HTH
Cordially
Pascal
Click to expand...
 
Top