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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - 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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
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