If names in one column match another, insert email..

**xi Slick ix** · 03-30-2012, 02:48 PM

Situation:

4 Columns of names: List Names, List Names Emails (Blank), All Names, All Names Emails

If person in List Names is also on All Names, insert corresponding email address (from All Names' Emails) in List Names Emails

Example Code
Example-Email-Insert.xlsx

I got the following Conditional Formatting Code from one of the Helpful Mods so far - purpose was to match names in two different columns.

Please Login or Register  to view this content.

With the condition it this case (when true) highlights a cell a given color

Also This:

Please Login or Register  to view this content.

Thought one of these might be tweaked to fit my need

Any help would be great, thanks
Slick

**Dennis7849** · 03-30-2012, 03:07 PM

This may work better for you. See your modified sample workbook.

**galvinpaddy** · 03-30-2012, 05:56 PM

Hello,

You could also try the attached, it uses alot more formula's but enables you to have as many names as you want in Columns A & F, with the rest (as long as you copy the formulas down) of the cells auto filling for you.

galvinpaddy.