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:
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]Sheet 1[/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl65"]Column 1[/TD]
[TD="class: xl65"]Column 2[/TD]
[/TR]
[TR]
[TD]Option 1[/TD]
[TD]Code 1[/TD]
[/TR]
[TR]
[TD]Option 2[/TD]
[TD]Code 2[/TD]
[/TR]
[TR]
[TD]Option 3[/TD]
[TD]Code 3[/TD]
[/TR]
[TR]
[TD]Alt 2[/TD]
[TD]Code 4[/TD]
[/TR]
[TR]
[TD]Alt 4[/TD]
[TD]Code 5[/TD]
[/TR]
[TR]
[TD]Alt 5[/TD]
[TD]Code 6[/TD]
[/TR]
[TR]
[TD]Other 1[/TD]
[TD]Code 7[/TD]
[/TR]
[TR]
[TD]Other 2[/TD]
[TD]Code 8[/TD]
[/TR]
</tbody>[/TABLE]
And an example of the second.
[TABLE="width: 206"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD]Sheet 2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Column 1[/TD]
[TD]Column 2[/TD]
[TD]Column 3[/TD]
[/TR]
[TR]
[TD]Origin 1[/TD]
[TD]Option 1[/TD]
[TD]Code 1[/TD]
[/TR]
[TR]
[TD]Origin 1[/TD]
[TD]Alt 2[/TD]
[TD]Code 4[/TD]
[/TR]
[TR]
[TD]Origin 1[/TD]
[TD]Other 1[/TD]
[TD]Code 7[/TD]
[/TR]
[TR]
[TD]Origin 2[/TD]
[TD]Option 1[/TD]
[TD]Code 1[/TD]
[/TR]
[TR]
[TD]Origin 2[/TD]
[TD]Alt 2[/TD]
[TD]Code 4[/TD]
[/TR]
[TR]
[TD]Origin 2[/TD]
[TD]Other 1[/TD]
[TD]Code 7[/TD]
[/TR]
[TR]
[TD]Origin 3[/TD]
[TD]Option 2[/TD]
[TD]Code 2[/TD]
[/TR]
[TR]
[TD]Origin 3[/TD]
[TD]Alt 4[/TD]
[TD]Code 5[/TD]
[/TR]
[TR]
[TD]Origin 3[/TD]
[TD]Other 1[/TD]
[TD]Code 7[/TD]
[/TR]
[TR]
[TD]Origin 4[/TD]
[TD]Option 3[/TD]
[TD]Code 3[/TD]
[/TR]
[TR]
[TD]Origin 4[/TD]
[TD]Alt 4[/TD]
[TD]Code 5[/TD]
[/TR]
[TR]
[TD]Origin 4[/TD]
[TD]Other 1[/TD]
[TD]Code 7[/TD]
[/TR]
[TR]
[TD]Origin 5[/TD]
[TD]Option 3[/TD]
[TD]Code 3[/TD]
[/TR]
[TR]
[TD]Origin 5[/TD]
[TD]Alt 5[/TD]
[TD]Code 6[/TD]
[/TR]
[TR]
[TD]Origin 5[/TD]
[TD]Other 2[/TD]
[TD]Code 8[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]Sheet 1[/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl65"]Column 1[/TD]
[TD="class: xl65"]Column 2[/TD]
[/TR]
[TR]
[TD]Option 1[/TD]
[TD]Code 1[/TD]
[/TR]
[TR]
[TD]Option 2[/TD]
[TD]Code 2[/TD]
[/TR]
[TR]
[TD]Option 3[/TD]
[TD]Code 3[/TD]
[/TR]
[TR]
[TD]Alt 2[/TD]
[TD]Code 4[/TD]
[/TR]
[TR]
[TD]Alt 4[/TD]
[TD]Code 5[/TD]
[/TR]
[TR]
[TD]Alt 5[/TD]
[TD]Code 6[/TD]
[/TR]
[TR]
[TD]Other 1[/TD]
[TD]Code 7[/TD]
[/TR]
[TR]
[TD]Other 2[/TD]
[TD]Code 8[/TD]
[/TR]
</tbody>[/TABLE]
And an example of the second.
[TABLE="width: 206"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD]Sheet 2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Column 1[/TD]
[TD]Column 2[/TD]
[TD]Column 3[/TD]
[/TR]
[TR]
[TD]Origin 1[/TD]
[TD]Option 1[/TD]
[TD]Code 1[/TD]
[/TR]
[TR]
[TD]Origin 1[/TD]
[TD]Alt 2[/TD]
[TD]Code 4[/TD]
[/TR]
[TR]
[TD]Origin 1[/TD]
[TD]Other 1[/TD]
[TD]Code 7[/TD]
[/TR]
[TR]
[TD]Origin 2[/TD]
[TD]Option 1[/TD]
[TD]Code 1[/TD]
[/TR]
[TR]
[TD]Origin 2[/TD]
[TD]Alt 2[/TD]
[TD]Code 4[/TD]
[/TR]
[TR]
[TD]Origin 2[/TD]
[TD]Other 1[/TD]
[TD]Code 7[/TD]
[/TR]
[TR]
[TD]Origin 3[/TD]
[TD]Option 2[/TD]
[TD]Code 2[/TD]
[/TR]
[TR]
[TD]Origin 3[/TD]
[TD]Alt 4[/TD]
[TD]Code 5[/TD]
[/TR]
[TR]
[TD]Origin 3[/TD]
[TD]Other 1[/TD]
[TD]Code 7[/TD]
[/TR]
[TR]
[TD]Origin 4[/TD]
[TD]Option 3[/TD]
[TD]Code 3[/TD]
[/TR]
[TR]
[TD]Origin 4[/TD]
[TD]Alt 4[/TD]
[TD]Code 5[/TD]
[/TR]
[TR]
[TD]Origin 4[/TD]
[TD]Other 1[/TD]
[TD]Code 7[/TD]
[/TR]
[TR]
[TD]Origin 5[/TD]
[TD]Option 3[/TD]
[TD]Code 3[/TD]
[/TR]
[TR]
[TD]Origin 5[/TD]
[TD]Alt 5[/TD]
[TD]Code 6[/TD]
[/TR]
[TR]
[TD]Origin 5[/TD]
[TD]Other 2[/TD]
[TD]Code 8[/TD]
[/TR]
</tbody>[/TABLE]
Thank you for your help!