| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using Concatenate to create formulas?
Hello,
I would like to create a formula based on values in a set of cell, for instance cell A1="Team" cell A2="A" In cell A4 I would like to get a formula "=+TeamA". TeamA is a named range in a different sheet in the workbook. I tried this =CONCATENATE("=+";A1;A2) but it didn't work. The value of cell A2 is a variable where I may enter the value "B" to generate a new formula: "=+TeamB". Can it be done? How? BR Thor |
|
#3
|
|||
|
|||
|
Great!
Thanks a lot. Now I can do a lot more, a lot easier! "Don Guillett" wrote: try this idea =INDIRECT(a1&a2) -- Don Guillett SalesAid Software "Thor" wrote in message ... Hello, I would like to create a formula based on values in a set of cell, for instance cell A1="Team" cell A2="A" In cell A4 I would like to get a formula "=+TeamA". TeamA is a named range in a different sheet in the workbook. I tried this =CONCATENATE("=+";A1;A2) but it didn't work. The value of cell A2 is a variable where I may enter the value "B" to generate a new formula: "=+TeamB". Can it be done? How? BR Thor |
|
#4
|
|||
|
|||
|
glad it helped
-- Don Guillett SalesAid Software "Thor" wrote in message ... Great! Thanks a lot. Now I can do a lot more, a lot easier! "Don Guillett" wrote: try this idea =INDIRECT(a1&a2) -- Don Guillett SalesAid Software "Thor" wrote in message ... Hello, I would like to create a formula based on values in a set of cell, for instance cell A1="Team" cell A2="A" In cell A4 I would like to get a formula "=+TeamA". TeamA is a named range in a different sheet in the workbook. I tried this =CONCATENATE("=+";A1;A2) but it didn't work. The value of cell A2 is a variable where I may enter the value "B" to generate a new formula: "=+TeamB". Can it be done? How? BR Thor |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create multiple formulas in 1 cell | Excel Worksheet Functions | |||
| create a list of worksheet names (from a single folder, or open files) | Excel Discussion (Misc queries) | |||
| create links for formulas | Excel Worksheet Functions | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| How do I create a formula that will multiply a 5% of a value >$150 | Excel Worksheet Functions | |||
Linear Mode
