| 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) | |||
Linear Mode
