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 |
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 |