Hi,
I have two data sets. Data 1 has only 1 column, which is the company's full
name. Data 2 has 2 columns, which are company name's abbreviation and the
code. I want to link the code to Data 1 by the company's name. However,
because the name column in both data sets are not exactly matched. I can not
do Vlookup.
Can any of you give me some suggestions? thanks a lot

Example:
Data 1:
Chase Manhattan Bank

Data 2:
Chase 098848