Cross-Reference Keywords in Excel to Google Search Results to Find Identifiers

Ends 28 Feb 2018 (in 3 months)

I need a PPH Pro to classify the companies in column A of the attached spreadsheet by Type, listed in column H, for each of which a description is provided. The company names were pulled from the email addresses, hence their strange format in some instances.
I imagine that the easiest way to do this is using VBA to run a keyword search of each item in Column A with Google, and to then paste the first result into an adjoining column. The result should be an enough of an indication of what the firm does. For results that return no clear description, simply put UNKNOWN.
Other ideas are welcome.


Sign up to apply →

Posted on peopleperhour.com





Know a freelancer that can do this job?

Earn lifetime commission for every freelancer you refer, by becoming an affiliate. Find out more

Share this job: