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

$10-30 AUD

Fullført

Lagt ut

omtrent 5 år siden

$10-30 AUD

Betalt ved levering

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

Excel

Prosjekt-ID: 19223167

Om prosjektet

5 forslag

Eksternt prosjekt

Aktiv 5 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

Tildelt til:

@Mokshith30

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 Thanks

$30 AUD om 1 dag

5,0

(32 omtaler)

4,1

5 frilansere byr i gjennomsnitt $56 AUD for denne jobben

@schoudhary1553

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. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

$100 AUD om 2 dager

4,9

(290 omtaler)

7,7

@sevillajk01

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 om 1 dag

5,0

(23 omtaler)

4,3

@shopshoppy

can do easily

$97 AUD om 1 dag

0,0

(0 omtaler)

0,0

@sayu4login

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 om 1 dag