Concatenate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is my problem; (Amongst many)

Sheet2 is named Cindy and in cell b12 is the value $100

In Sheet1 cell a1 = Cindy. Also in Sheet1 I would like to write a formula
that uses cell a1 to get the sheet name (Cindy) and combine it with B12 to
return the value $100.

Any help will be greatly appreciated. Thanks.
 
=INDIRECT("'"&A1&"'!B12")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Bob - Thank you. It worked perfect.

Bob Phillips said:
=INDIRECT("'"&A1&"'!B12")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
Click to expand...
 
You must log in or register to reply here.

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 Formula Porblems 1
If cell value is between XX and XL, display B 4
Modify a Formula 4
Comparing 3 columns? 5
add hyperlink using sheet names and cells(i,j) 3
"IF" formula problem 1
EXCEL - IF(IFERROR(VLOOKUP question 0
if true, if not nested if funcion 2

Back
Top