Copying cells from one sheet based on another sheet

[chauber]

Sorry if the title doesn't make much sense, I will try to explain better. I have a set of data on sheet 1 that looks like the following:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column 1
[/TD]
[TD]Column 2
[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

On sheet 2 I have data that looks like the following:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column 1
[/TD]
[TD]Column X
[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]text1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]text1
[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]text2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]text2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]text2[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]text3[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]text4[/TD]
[/TR]
</tbody>[/TABLE]

How do I make a formula where if a Cell in Sheet 1 Column 1 equals a value in Sheet 2 Column 1, then text from Sheet 2 Column X is copied to Sheet 1 Column 2? Sheet 1 would look like the following

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column 1
[/TD]
[TD]Column 2
[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]text1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]text2[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]text3[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]text4[/TD]
[/TR]
</tbody>[/TABLE]
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]Column 1
[/TD]
[TD]Column 2
[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
</body>

 

[mrshl9898]

Can you not just pivot sheet 2 to create sheet 1? If not then why?

 

[Fluff]

If you want a formula, how about
=INDEX(Sheet2!$X$2:$X$10,MATCH(A2,Sheet2!$A$2:$A$10,0))