A question for Match and Lookup

[Bin]

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

[Bob Phillips]

How about this

=INDEX(G20:G25,MIN(IF(ISNUMBER(MATCH(LEFT(A21,LEN(F20:F25)),F20:F25,0)),ROW(
F20:F25)-ROW(F20)+1)))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Bin" <Bin@discussions.microsoft.com> wrote in message
news:7A3F98D0-3274-46E9-BE08-CD62490948E5@microsoft.com...
> 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