Hi,
I have a database of different company names and their respective stock symbols (spreadsheet 1) and in another spreadsheet I have company name and descriptions (spreadsheet 2) that aren't exactly written the same way as they are in my initial database. I would like to try to use some parts of the company name (spreadsheet 2) to those in spreadsheet 1 even if they are not exactly the same. So I was thinking of using the search function but my attempts don't seem to work very well in an array so far. Once I have that matched, I would probably use an index match to refer to another column in my database (spreadsheet 1) to give me the ticker of that company.
I was hoping you'd help me figure out the best way of doing that.
Here is an example of descriptions and my corresponding database.
Spreadsheet 2 descriptions
<colgroup><col></colgroup><tbody>
</tbody>
Spreadsheet 1 database
<colgroup><col></colgroup><tbody>
</tbody>
<colgroup><col></colgroup><tbody>
</tbody>
<colgroup><col></colgroup><tbody>
</tbody>
<tbody>
</tbody>
<colgroup><col></colgroup><tbody>
</tbody>
<colgroup><col></colgroup><tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
Thanks a lot for your help in advance!!!
I have a database of different company names and their respective stock symbols (spreadsheet 1) and in another spreadsheet I have company name and descriptions (spreadsheet 2) that aren't exactly written the same way as they are in my initial database. I would like to try to use some parts of the company name (spreadsheet 2) to those in spreadsheet 1 even if they are not exactly the same. So I was thinking of using the search function but my attempts don't seem to work very well in an array so far. Once I have that matched, I would probably use an index match to refer to another column in my database (spreadsheet 1) to give me the ticker of that company.
I was hoping you'd help me figure out the best way of doing that.
Here is an example of descriptions and my corresponding database.
Spreadsheet 2 descriptions
407 International Inc. |
407 International Inc. |
Access Justice Durham |
AerCap Ireland Capital Designated Activity Co. |
AerCap Ireland Capital Designated Activity Co. |
Aeroports de Montreal |
AIMCo Realty Investors LP |
AIMCo Realty Investors LP |
Algonquin Power & Utilities Corp. |
Algonquin Power & Utilities Corp. |
AltaLink LP |
AltaLink LP |
AltaLink LP |
Anheuser-Busch InBev Finance Inc. |
Anheuser-Busch InBev Worldwide Inc. |
Aroundtown SA |
Artis Real Estate Investment Trust |
AT&T Inc. |
AT&T Inc. |
AT&T Inc. |
Bank of America Corp. |
Bank of America Corp. |
Bank of Montreal |
Bank of Montreal |
Bank of Montreal |
Bank of Montreal |
Bank of Montreal |
Bank of Montreal |
Bank of Montreal |
The Bank of Nova Scotia |
The Bank of Nova Scotia |
The Bank of Nova Scotia |
The Bank of Nova Scotia |
The Bank of Nova Scotia |
BC Telecom Inc. |
bcIMC Realty Corp. |
Bell Canada |
Bell Canada |
Bell Canada |
Bell Canada |
Bell Canada |
Bell Canada |
Borealis Infrastructure Trust |
BP Capital Markets PLC |
Brookfield Asset Management Inc. |
Brookfield Infrastructure Finance ULC |
Brookfield Renewable Energy Partners ULC |
<colgroup><col></colgroup><tbody>
</tbody>
Spreadsheet 1 database
407 INTERNATIONAL INC |
407 INTERNATIONAL INC |
407 INTERNATIONAL INC |
<colgroup><col></colgroup><tbody>
</tbody>
AEROPORTS DE MONTREAL |
AEROPORTS DE MONTREAL |
<colgroup><col></colgroup><tbody>
</tbody>
ALGONQUIN POWER CO |
ALGONQUIN POWER CO |
<colgroup><col></colgroup><tbody>
</tbody>
ANHEUSER-BUSCH INBEV FIN |
<tbody>
</tbody>
ALTALINK INVESTMENTS LP |
ALTALINK INVESTMENTS LP |
ALTALINK LP |
ALTALINK LP |
<colgroup><col></colgroup><tbody>
</tbody>
BANK OF MONTREAL | |
BANK OF MONTREAL
<tbody> </tbody> |
<colgroup><col></colgroup><tbody>
</tbody>
BCIMC REALTY CORP
<tbody> </tbody> |
<tbody>
</tbody>
BOREALIS INFRASTR TRUST |
<tbody>
</tbody>
Thanks a lot for your help in advance!!!