VLookup plus

[nbarclay]

I'm trying to match column values in Column A, with Column C. So if there's match, I want the corresponding value in Column D to populate in Column B.
In other words, Column B (Email) should populate with the email (from column D) for the user in Column A. The user in column A may have multiple entries. Columns C and D are a list of each user and their email address.

Not a great explanation, but allow me to visually show you what I'm looking for:

[TABLE="width: 500"]
[TR]
[TD]Column A
[/TD]
[TD]Column B
[/TD]
[TD]Column C
[/TD]
[TD]Column D
[/TD]
[/TR]
[TR]
[TD]FullName
[/TD]
[TD]Email
[/TD]
[TD]Name
[/TD]
[TD]Email List
[/TD]
[/TR]
[TR]
[TD]User1
[/TD]
[TD][/TD]
[TD]User1
[/TD]
[TD]User1@company.com
[/TD]
[/TR]
[TR]
[TD]User1
[/TD]
[TD][/TD]
[TD]User2
[/TD]
[TD]User2@company.com
[/TD]
[/TR]
[TR]
[TD]User1
[/TD]
[TD][/TD]
[TD]User3
[/TD]
[TD]User3@company.com
[/TD]
[/TR]
[TR]
[TD]User1
[/TD]
[TD][/TD]
[TD]User4
[/TD]
[TD]User4@company.com
[/TD]
[/TR]
[TR]
[TD]User2
[/TD]
[TD][/TD]
[TD]User5
[/TD]
[TD]User5@company.com
[/TD]
[/TR]
[/TABLE]

 

[RoryA]

Welcome to the forum.

=VLOOKUP(A2,C:D,2,false)

should do it.

 

[nbarclay]

THANK YOU SO MUCH! I was working on this for hours yesterday. That worked!! You made my day!

 

[RoryA]

Glad to help.