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.
=A2=VLOOKUP(A2,$C$2:$C$446,1,FALSE)
With the condition it this case (when true) highlights a cell a given color

Also This:
=IF(ISERROR(VLOOKUP(A5,$H$3:$H$8,1,FALSE)),"Not Found","Found")
Thought one of these might be tweaked to fit my need

Any help would be great, thanks
Slick