Combine/compare spreadsheets?

If I have two speadsheets. One with multiple columns and some rows have missing data. So if I have spreadsheet one with 10 fields and two of them are "Email" and "Website" and lets say, quite a few are missing email data.

Now I have spreadsheet 2 which only has 2 columns; "Email" and "Website".

So can I merge these so that everywhere "Website" on spreadsheet 2 matches spreadsheet 1, it fills in the missing email data?


For example:

Spreadsheet 1:


Spreadsheet 2:


How could I take those two and merge them correctly.

Install xlst libraries for python , or convert the files to csv format . And then process them with the required logic and conditions , then convert back to original form . You could also try any other language , don't know if you can do this within excel or not .

So basically you are saying to make some kind of program for this?