There are two lists of data in Excel. Each list contains a company name and some other data.
However the company name in list one (26,000 records) is slightly different than the company name in list two (3,667 records)
In list one (the primary data source) there is also a company ID number.
For example in list one the company name might be written as: "Envico Doors Pty Ltd" with an ID example of SF000989876asd while in list two that same company is written as "Envico Doors".
Another example: in list one the company is called: "MuntersP/L" and in list two the company is written as: "Munters Pty Ltd"
The job is to attach the Company ID from list one to as many of the companies in list two that can be matched.
There may be cases where the company in list two does not match a company in list one and this should be left with no company ID.
Sample Excel attached
Need this job done today if possible . . . . .
7 freelancers are bidding on average $139 for this job
I have gone through the sample. You want only the SF_ID column. I have enough experience on excel and also I'm interested to work with excel I can do this project within 3 days. Thank you