Performing queries between one or more excel files

Job ID: 34006143

Budget: $10 – $25 USD

Performing queries between one or more excel files.

Hi everyone,
I need some help to perform some query using Excel or GoogleSpreadsheet.

Let me explain the problem:

I've got 1 excel file that contain "Company Name", "Company Website" & "Email" (plus other columns not really relevant).

Some companies has got empties values in "Email" field.

So I've used a software to perform a scraping activity.
Basically the software navigate each links and search for email fields.

The output is a new file excel that contain "Company Website" and "Email".

In Total I've got 18 raw excel files plus 18 excel files given from Scraping software.

The goal is to compare/lookup "Company website" from excel file A with "Company Website" from excel file B, If the values ​​are the same we must copy "Email" values from excel file B and append it into excel file A in the correct row.

Check attached examples files
Please ping me for futher info, we can start an Anydesk session in order to show you what is the result I expect.

Thanks everyone for your kindly attention