Compare & Insert

[miyengar]

Need help!
I have two tables with 5 columns each. The first two columns in both tables contain ID#s and Names. The third column contain job titles in both tables. Table 2 has many more records that table1 - in other words table 1 is a subset of table 2.
I want to compare these titles in the two tables and identify which ones are different. If they differ, I want to be able to insert the titles from table 1 into table 2, column 6.

Many thanks!

 

[Robert Mika]

Will this work for you?
Excel 2010

	A	B	C	D	E	F	H	I	J	K	L	M
1			Job title
2			A						A	B
3			B						C	D
4			C						F	E
5			D							G
6			F							H
7			E
8			G
9			H
10
11
12
13
14
15
16

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Array Formulas Cell Formula K2 {=INDEX($C$1:$C$100,SMALL(IF(ISNA(MATCH($C$2:$C$100,$J$2:$J$50,0)),ROW($2:$100),""),ROW(A1)))} <thead> </thead><tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

 

[miyengar]

Thanks! Yes, this logic works fine. Again, thanks!

 

[Robert Mika]

You are welcome.