About Us

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
create multiple formulas in 1 cell	anam_cara	Excel Worksheet Functions	2	May 11th 05 05:56 AM
create a list of worksheet names (from a single folder, or open files)	Drew	Excel Discussion (Misc queries)	2	April 15th 05 04:58 PM
create links for formulas	weclean	Excel Worksheet Functions	0	April 4th 05 10:09 PM
Way to make Excel only run certain formulas on a worksheet?	jrusso	Excel Discussion (Misc queries)	0	January 12th 05 04:23 PM
How do I create a formula that will multiply a 5% of a value >$150	babydear12	Excel Worksheet Functions	2	October 29th 04 01:00 AM

Menu

About Us