Combine the data in two Google sheets by looking up a common domain name

I have two Google Sheets of data.

Sheet 1 has 16,000 rows that includes a domain name

Sheet 2 has about 9,000 row that includes a domain name

I want you to write a Google sheets function/vlookup etc that takes each row in sheet 1, take the domain name, looks for a match in sheet 2.

Where a match is found, the data in the row in sheet 2 is copied across and added to the matching row in sheet 1.

Sheet 1 might have multiple rows with the same domain name

Sheet 2 might not have a domain name match in sheet 1.

So in the end all the data is held on sheet 1

I've attached two same excel sheets so you can see what needs to be done.

I'm looking for the formula to be build in Google Sheets please

Skills: Excel

See more: google sheets query, google sheets 2018, home google sheets, vlookup google sheets, google sheets barcelona, google sheets formulas, importrange google sheets, google sheets for seo, php mysql data google spreadsheet, web based show gps data google map, scrape data google map, excel combine data, updating data google map, feeding xml data google maps, show custom mysql data google maps, import nmea data google earth, combine data databases, automatic import data google docs google calendar, update data google maps, excel combine data sheets

About the Employer:
( 13 reviews ) Brisbane, Australia

Project ID: #19223167

Awarded to:


Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance T More

$30 AUD in 1 day
(32 Reviews)

5 freelancers are bidding on average $56 for this job


Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More

$100 AUD in 2 days
(290 Reviews)

hello! let me do it for you. Just award the project to me and I will take care of the rest. hope you will consider me, thanks.

$25 AUD in 1 day
(23 Reviews)

can do easily

$97 AUD in 1 day
(0 Reviews)

Hi Gerard, I understand your requirement for data manipulation in google sheets. I an expert with excel as well as google sheets. I think I will be the perfect candidate to do this work. Let's discuss more over chat.

$29 AUD in 1 day
(0 Reviews)