Comparing product models between two columns Matching the ones on both marking the ones ..

[ic3cold]

I have this problem I have two columns with product models I need to compare

The first one has the products I have, and I need to check if they have a match on the second, if they don't, those are discontinued.
The second column might contain new products not yet entered, so I have to compare those also.

here's what my columns with headers look:


Mod Item No.
00001713 00041333003573
00004 00041333003580
00009 00041333003597
00009W 00041333003733
000223 00041333005300
00041333003573 00041333411354
00041333003580 00041333423357
00041333003597 00041333429359
00041333003733 0006905584169
00041333005300 0006905584751
00041333411354 000722810000
00041333423357 000732500000
00041333429359 000764511000
000421 000885911000
000438 000901900000
00052 000938511000
00053 0011106
00054 0011247
00054NC 0011866
0006905584169 001230001100
0006905584751 001342MIIU
0006905584752 00136A
0006905585172 00145ATLUS
0006905585298 00146A
0006905585299 001830505000
0006905585351 001830505001
0006905585679 001830505009
000700 0020792

Both columns are formatted as text, and I need to check if column1 matches the value in column2, probably create a third that will have the matching values in both plus all the ones that are only on the second, which are the new one.