This is driving me nuts. I'm sure its pretty easy but have not been able to find the solution.

I have two columns of text data ( song titles) I want to see which title from column A also appears in column B.
What is challenging is that the titles are not exact matches, although the first 5-6 characters are the same. I have been using the following but it only works for exact matches.

can someone please help.




=IF(ISERROR(MATCH(C3,$H$1:$H$339,0)),"",C3)