A question for Match and Lookup

B

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
 
B

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)
 
Top