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:
<tbody>
</tbody>
On sheet 2 I have data that looks like the following:
<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
<tbody>
</tbody>****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody></body>
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>
Column 1 | Column 2 |
A | |
B | |
C | |
D |
<tbody>
</tbody>