Concatenate
 

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.

Concatenate
 

=INDIRECT("'"&A1&"'!B12")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jordan" wrote in message
...
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.

Concatenate
 

=INDIRECT(A1 & "!B12")

Regards

Trevor


"Jordan" wrote in message
...
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.

Concatenate
 

Bob - Thank you. It worked perfect.

"Bob Phillips" wrote:

=INDIRECT("'"&A1&"'!B12")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jordan" wrote in message
...
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.