concatenated text strings as formula

  • Thread starter Thread starter Sarah
  • Start date Start date
S

Sarah

How do you use a concatenated text string as a formula?
i.e., cell A1 has the worksheet name (i.e., "Sheet1") and
cell B1 has the cell reference ("C3"), so how would you
make a formula that would read Sheet1!C3?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If function across sheets prints value of cell 4
Evaluate string as a formula 3
Concatenation Setback 4
Use concatenated text as name in formulas 2
Why is the formula displaying rather than the actual value? 11
Concatenate 2
CONCATENATE 4
Use array/braces **WITHIN** a formula? 3

Back
Top