Cell value equal to other cell reference

[fcohen]

Hi all,
In cell A1 I have the text: "B1"
In cell B1 I have the value: "Good Morning!"
In cell A2 I want to have a formula that according to the value on A1 gets the value of that cell.

In this case the formula would return "Good Morning".

Thanks for your reply!
FC.

 

[Gary McMaster]

Maybe the "Indirect" function?

Sheet1

*	A	B
1	B1	Good Morning
2	Good Morning	*

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:93px;"><col style="width:117px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula A2 =INDIRECT(A1) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[fcohen]

Thanks Gary McMaster, it solved my dummy problem!