Formula to copy cell value

[Slumbery]

Hey, I am looking for a formula to copy value from specific cell to another.
For instance
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Copy Me[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Copy Me 3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want in B to copy cell A2 and C to copy cell A1 regardless of the values that will be changing in just cell A. So whatever changes I do in cell A is already copied on its own in cell B & C corresponding to its respectable cell.

 

[mumps]

In B1 place: =A2
In C1 place: =A1

 

[Marcílio_Lobão]

Slumbery, Good afternoon.

[TABLE="class: grid, width: 300, align: center"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]Copy me[/TD]
[TD="align: center"]=A2[/TD]
[TD="align: center"]=A1[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]Copy Me 3[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]

Is it what you want?
I hope it helps.

 

[Slumbery]

How about if A3 and 4 are merged cells and I want the value to be copied in C2?

 

[mumps]

In C2: =A3