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