Using Concatenate to create formulas?

[Thor]

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

 

[Don Guillett]

try this idea
=INDIRECT(a1&a2)

 

[Thor]

Great!

Thanks a lot. Now I can do a lot more, a lot easier!

 

[Don Guillett]

glad it helped