When conditions are met pull data from one sheet to another?

[amitk]

Hello everyone,

This is what I'm trying to achieve.
My sheet1 have bunch of data with columns like Name, email, Contact no., address, Receipt no.,Donation amount, reference number, ID etc. with only Name,Donation amount, receipt no. is filled up and rest are empty.

My sheet 2 will have same columns with all other columns like name, address, contact no.,email ID etc filled up but only donation amt and reciept no. is empty.
Now I want to pull data from sheet2 to sheet1 if 'Names' in both the sheets are same.
How to achieve this?

(Additional Question:- Also can this be done if two conditions are met like for example Name and emails are same then pull the date from sheet2 to sheet1?)

 

[ETAF]

are the names identical ?
i would assume an email address to be unique
so could use email address only

you can append name & email together and search the 2 columns

But will names be identical/EXACT in both sheets ?????

A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.

something like

=index(column to return , match ( lookup cell, lookuprange , 0))
or appending to together
=index(column to return , match ( cell1&cell2, range1&range2 , 0))

 

[amitk]

Do You think it can work on guesswork?!!
In order to avoid wasting professors' time, you should upload a supported file with a sufficient explanation of what is required, with the form of the desired results.

It includes sensitive data but I will edit it with fake sample data and upload it.

 

[amitk]

are the names identical ?
i would assume an email address to be unique
so could use email address only

you can append name & email together and search the 2 columns

But will names be identical/EXACT in both sheets ?????

A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.

Yes 95% of the names in sheet1 and sheet2 will be identical. I will upload the sample sheet in 2-3 days as it's on my office desktop. The problem with emails is sheet1 have email column empty.

 

[ETAF]

sounds like you can only use names
and so will only return a 95% match - also index/match or vlookup will only return 1st value it finds - o if you have duplicate names but different account - that may also give an error

index( sheet2!column range for return , match(sheet1!cell with name , sheet2!columnnrange of names , 0 ))

index( sheet2!A2:A400, match(sheet1!A2,Sheet2!B2:B400,0))

 

[amitk]

sounds like you can only use names
and so will only return a 95% match - also index/match or vlookup will only return 1st value it finds - o if you have duplicate names but different account - that may also give an error

index( sheet2!column range for return , match(sheet1!cell with name , sheet2!columnnrange of names , 0 ))

index( sheet2!A2:A400, match(sheet1!A2,Sheet2!B2:B400,0))

Thanks a lot. I will give it a try tomorrow and let you know.
Regarding duplicate names, I'm anyways going to delete duplicate names from sheet2 manually. In case of same name of two different people, I will have to check them manually and which one to be given preference. I don't mind first name in sheet2 getting pulled into sheet1 due to our program.