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!!!
