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

[jrleggett]

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

 

[t0azt]

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

 

[NeonRedSharpie]

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

[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.