# Matching data in two sheets then returning value from one to another

#### jrleggett

##### New Member
Hi there,

I am a bit of a newbie when it comes to advanced Excel so I hope I can explain this well enough but I really need help with a formula for excel 2010.

I basically have two sheets..

Sheet one has a list of email addresses in column A

Sheet two has another list of email addresses in column C and their corresponding profile text next to it in column D

I want a formula that will take the email address from sheet 1 column A, look for a matching email address in sheet 2 column C, and if it finds a match, place the corresponding profile text from sheet 2 column D in sheet 1 column B

Again, hope this makes sense and I really appreciate any help!

J

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

#### t0azt

##### Board Regular
=VLOOKUP(A1,Sheet2!C:D,2,FALSE)

#### NeonRedSharpie

##### Well-known Member
=VLOOKUP(A1,Sheet2!C:D,2,FALSE)

Code:
``[COLOR=#333333]=IFERROR(VLOOKUP(A1,Sheet2!C:D,2,FALSE),"Email Not Found")[/COLOR]``

Might as well wrap it in an error in case the lists aren't identical.

Replies
4
Views
33
Replies
4
Views
106
Replies
5
Views
41
Replies
2
Views
47
Replies
1
Views
33

1,109,436
Messages
5,528,749
Members
409,834
Latest member
vexceled

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...