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:

Column 1	Column 2
A
B
C
D

<tbody>
</tbody>

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

Column 1	Column X
A	text1
A	text1
B	text2
B	text2
B	text2
C	text3
D	text4

<tbody>
</tbody>

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

Column 1	Column 2
A	text1
B	text2
C	text3
D	text4

<tbody>
</tbody>

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">

Column 1	Column 2
A
B
C
D

<tbody>
</tbody>

</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))