Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating a variable for file names
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating a variable for file names
Hello
Use INDIRECT in your formula : =VLOOKUP(INDIRECT(A1 & "!NUM"),INDIRECT(A1 & "!table"),2) HTH Cordially Pascal "BEAST" a écrit dans le message de news: ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating a variable for file names
thanks papou this works great you're the best!
"papou" wrote: Hello Use INDIRECT in your formula : =VLOOKUP(INDIRECT(A1 & "!NUM"),INDIRECT(A1 & "!table"),2) HTH Cordially Pascal "BEAST" a écrit dans le message de news: ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable names for named range | Excel Discussion (Misc queries) | |||
variable file names | Excel Discussion (Misc queries) | |||
creating a variable | New Users to Excel | |||
Variable Names in Formulas | Excel Discussion (Misc queries) | |||
Automatically creating file names | Excel Discussion (Misc queries) |