I thought I had my answer with index match, but it doesn't seem to work for me.
I have two spreadsheets, one with only unique data. The other one has repetitive data. I would like to paste data from Sheet 1, to a column in Sheet 2, when matches are found.
In my example below, the columns that data is being searched and matched for are: In Sheet 1, Column 1. And in Sheet 2, Column 2. If a match is found, the data from Sheet 1, Column 2, would be pasted into Sheet 2, Column 3.
Here's an example of the first spreadsheet:
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
And an example of the second.
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
Thank you for your help!
I have two spreadsheets, one with only unique data. The other one has repetitive data. I would like to paste data from Sheet 1, to a column in Sheet 2, when matches are found.
In my example below, the columns that data is being searched and matched for are: In Sheet 1, Column 1. And in Sheet 2, Column 2. If a match is found, the data from Sheet 1, Column 2, would be pasted into Sheet 2, Column 3.
Here's an example of the first spreadsheet:
Sheet 1 | |
Column 1 | Column 2 |
Option 1 | Code 1 |
Option 2 | Code 2 |
Option 3 | Code 3 |
Alt 2 | Code 4 |
Alt 4 | Code 5 |
Alt 5 | Code 6 |
Other 1 | Code 7 |
Other 2 | Code 8 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
And an example of the second.
Sheet 2 | ||
Column 1 | Column 2 | Column 3 |
Origin 1 | Option 1 | Code 1 |
Origin 1 | Alt 2 | Code 4 |
Origin 1 | Other 1 | Code 7 |
Origin 2 | Option 1 | Code 1 |
Origin 2 | Alt 2 | Code 4 |
Origin 2 | Other 1 | Code 7 |
Origin 3 | Option 2 | Code 2 |
Origin 3 | Alt 4 | Code 5 |
Origin 3 | Other 1 | Code 7 |
Origin 4 | Option 3 | Code 3 |
Origin 4 | Alt 4 | Code 5 |
Origin 4 | Other 1 | Code 7 |
Origin 5 | Option 3 | Code 3 |
Origin 5 | Alt 5 | Code 6 |
Origin 5 | Other 2 | Code 8 |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
Thank you for your help!