I need to find a way to match up Inventory item codes which were imported into excel from 2 different sources. I need them sorted so the ones with no matches would leave a blank cell i.e.

Source one

Column A

Item No.

HD638
HD6516
HD812
HD838
HD858
HDS014
HDS018
HDS0316


Column B

No. Sold

1000
500
600
50
100
600
450


Source 2

Column C

Item No.
HD638
HD6516
HD838
HDS014
HDS018
HDS0316



Column D

Qty on Hand

5000
2000
1000
5000
2000
500



Column E

On Order

1000