Matching Last Name / First Name from two sheets - adding Email addresses to third column

[SamFunzie]

Hi...

First post... looking for days for solution... finding information close to what we need, but...

Have two sheets, both very different, but each containing Last Name, First Name and a column for email addresses (one sheet has the email addresses entered, the other does not)

What we are trying to do is look for matches in Last/First columns between the two sheets and if/when found copy the email addresses from one sheet to the other.

Worksheet A: Last=B2 First=C2 Email Address=F2
Worksheet B: Last=A2 First=B2 Email Address=C2

Thanking you in advance for any assistance or guidance...

Sam

[Saarang84]

Hi,

Welcome to the Forum. Would be more clear, if you could provide us a workbook with sample data (insensitive) to work with.

[Glenn Kennedy]

Hi, Sam, in sunny CA - from here in cloudy, grey & windy Northern Ireland!!

Try this out:

[SamFunzie]

Mr Kennedy and Saarang84...

Thank you for replying... You are right, an example would have been better... (sorry)

I have done just that (I hope)... I hope this illustrates what we are trying to do...

Compare the two name columns... If a match is found (both last/first), copy the email in the second sheet to the corresponding column in the first sheet...



Mr Kennedy... I will try your suggested solution right away...

Thank you again...

SamF

[Saarang84]

Hi Sam,

Glenn's solution works fine.. Refer workbook attached.

[SamFunzie]

Mr Kennedy and Saarang84...

It took me some time to understand it and to get it to work, but I did...

Thank you Mr Kennedy for the help and the formula...

Thank you Saarang84 for testing the formula and adapting it to my late-coming example...

I really appreciate the time you took...

Best regards,

SamF