Comparing two columns to find out common text

[callsidd]

Hi,

I have a following serious query and dont know what to do? Please help.

I need to display common text by comparing Column A and B and also require to have unique value "ABC123" ........ with the text in Column C. Is there any way to do this?

Excel 2010
	A	B
1	ABC123 John David	David School
2	ABC012 Shawn Michael	Shawn Michael Org
3	ABC555 Shirley Olga	Olga College of Medicine
Sheet1