How to extract data & create database from different excel sheet

Closed
abrarali saiyed
Posts
1
Registration date
Wednesday July 24, 2013
Status
Member
Last seen
July 24, 2013
- Jul 24, 2013 at 02:25 AM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Jul 29, 2013 at 10:44 AM
Hi

I have data of around 4000 companies from one data sources in an spread sheet

I have data of M&A, Joint ventures and wholly owned subsidiaries which I collected from different data sources

The challenge is to find these 4000 companies in this other spreadsheets and extract information regarding these companies

As data was collected from different sources, the name of the companies are not necessarily matching, so can't use vlookup and other functions

kindly help

1 reply

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
Jul 29, 2013 at 10:44 AM
Hi Abrarali,

You say the companies aren't matching. Can you elaborate on that?

Is there always something in front or at the end? Are there numbers involved? Are there fixed distances?

Best regards,
Trowa
0