Find Partial Text Match between Two Columns of data

Hi Everyone,

I am relatively new to Excel. I am in the process of comparing two columns of data to determine whether the data in each column relate. Column A has the key name from one product in one system and Column B has the key name from the same product in another system. There are 55,000 rows of key names to go through and I would really like to find an easier way to compare then than just doing it by eye. The key names don't have to match exactly they just have to be similar. For example,

COLUMN A:
Bourbon Seagram BTL
SS Bailey's
Vodka Skyy BTL
SS House Rum

COLUMN B:
BTL Seagram
Bailey
BTL Skyy
Vodka (Column C would show that this doesn't match Column A)

Is there an easier way to go through the two columbs and find cells that don't match at all? Please help!!!


Thanks,

Samybelen

Here are two links that might be helpful:

http://www.excelforum.com/excel-tips...for-excel.html

http://www.mrexcel.com/forum/excel-q...planation.html