I have two worksheets, the first contains a column of text values, the second contains three columns of text values. What I need to do is look at the first sheet and where it contains data from the first two columns of the second sheet, append the third column to the text. eg
1st sheet:
aaabbbccc
aaacccddd
aaabbbddd
bbbcccddd
2nd sheet
aaa bbb eee
bbb ccc fff
afterwards I want the 1st sheet to look like:
aaabbbccceee
aaacccddd
aaabbbdddeee
bbbcccdddfff
Bookmarks