Fill cell value based on value from another sheet- In dummy terms!

[LAL2212]

Hello,
I am having some trouble in a serious situation!

I am really not a wiz at excel, but i'm sitting at my desk at work and my boss is on my back about trying to make this work. Someone needs to explain this to me in dummy terms!

Basically, i have 2 excel documents. Doc 1: A Database of names, emails, phone numbers, website etc...
The other document (Doc 2) has a select number of names that have clicked through to the email my business has sent out. Basically, i want to be able to merge the documents so that the right phones numbers, websites etc from Doc 1 are populated into the right cells which correspond to the right name in Doc 2.

Thanks guys!

[vlady]

index/match i think is what you wanted....

say in doc2 name in A1...
in B1 = index(rangeofemailsfromdoc1,match(nameindoc2A1,rangeindoc1ofnames))
something like this..
in doc1
=index(Doc1!B1:B10,match(Doc2A1,Doc1A1:A10))

Doc1!B1:B10 ----the emails
Doc1A1:A10 - the names

if you can give us a sample dummy file, we can create the formula's for you to study...

[LAL2212]

Thanks Vlady!

I still don't understand what the formula means, maybe this is just out of my league.
I have attached a small snippet of the documents for your reference.

Thanks

[vlady]

can you try this in doc2

=IFERROR(INDEX('[Doc 1- database.xlsx]Sheet1'!$B$2:$B$500,MATCH(A2,'[Doc 1- database.xlsx]Sheet1'!$A$2:$A$500,0)),"")
--this should return the email address as sample...

[vlady]

here's a sample of the file doc2...Doc 2- those who did not open emails.xlsx

[LAL2212]

Thank you,
I will have a look at this.

E