PDA

View Full Version : [SOLVED] Compare two lists First Name Last Name - If both match add Email Address



JinkyJulie
06-03-2014, 07:48 AM
Good day... and Hi

First time in Excel forum... usually looking for Word VBA help... Thank you for taking the time...

I have two very different sheets (different data, order, cells, length)... have Last Name | First Name | EMail columns in both - one no emails, one has them... I would like to compare the two lists and if a match is found in both name columns, add the email address from the one to the respective blank column in the other... cut and paste too tedious...

Sheet "ABC" Last Name=B2 First Name=C2 Email=F2 (no emails... this is where I want to copy to)
Sheet "XYZ" Last Name=A2 First Name=A2 Email=C2 (this is where the emails are)

VBA, Excel formula... does not matter... I have been searching the WWW for days... other posts come close but unable to find or adapt whatever they have to my needs.... :(

Just trying to save time...

(If I am not clear... let me know and I will reword my question)

Thank you again for your time and help...

JJ

ashleyuk1984
06-03-2014, 08:08 AM
Hi.


Sheet "XYZ" Last Name=A2 First Name=A2 Email=C2

Please clarify. Last Name and First Name columns.
Thanks

JinkyJulie
06-03-2014, 08:34 AM
My apologies for confusion...

Sheet "ABC" Last Name=B2 First Name=C2 Email=F2
Sheet "XYZ" Last Name=A2 First Name=B2 Email=C2

Thank you ashleyuk1984for catching that.... :doh:

JJ

JinkyJulie
06-10-2014, 07:10 AM
I finally found an answer on another forum...

For those interested... I adapted this to my needs...

=IFERROR(INDEX(SheetABC!$C$2:$C$16,MATCH(1,(SheetABC!$A$2:$A$16=B60)*(Sheet ABC!$B$2:$B$16=SheetXYZ!C60),0)),"Not Here")

Thank you (I guess)... :whistle:

JJ