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
5 freelancers are bidding on average $56 for this job
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.