Help combining information from 2 sheets

[snapitsports]

My hobby business is race photography. We go out and shoot races and then upload them to our servers and then using an excel sheet with first name, last name, bib (race) number, and email address...we are able to upload this into the software to send out automated emails to each participant.

A few times now, I have gotten a file (sometimes 2) that have all this information but not all on the same and definitely not the same amount of entries on each as the email list only lists those that gave emails and not everyone else.

So I have tried to find a way to create a formula that would look at first name and last name and compare it to the other sheet and, if the same, it would copy over the email address to the field...otherwise leave it blank or put N/A or something.

Can someone please help?

Sheet 1 looks like this...

4	John	Doe
5	Jane	Doe
6	User	Name
7	Susan	Doe
8	John	Williams

<tbody>
</tbody>

And then Sheet 2 looks like this...

John	Doe	john.doe@gmail.com
User	Name	user.name@gmail.com
John	Williams	john.williams@gmail.com

<tbody>
</tbody>

And of course, I need it to combine to be...

4	John	Doe	john.doe@gmail.com
5	Jane	Doe
6	User	Name	user.name@gmail.com
7	Susan	Doe
8	John	Williams	john.williams@gmail.com

<tbody>
</tbody>

Hope this is pretty cut and dry. Thanks for any help you can shoot me!

 

[sergioMabres]

You would like to use vlookup and iserror
Using lastname&", "&name look into sheet2 and get back the email
Sergio