Here's what i am trying to accomplish...

In column A i have a list of about 2000 accounts each that contain multiple email addresses. In column C i have blank spaces to move my new codes to. In column D i have the same list of individual accounts only without any duplicates and in column E i have the actual codes i need to copy over.

I had to generate a unique code for each account so I copied all the accounts out to a new column (D), removed duplicates generated codes for each account and pasted the results next to the individual account (E).

Here's where the problem comes in i'm trying to copy the codes to from Column E to Column C only if the data in Column A matches whats next to that code in Column E.
For example...

A B C D E
Account1 [email protected] Code1 Account1 Code1
Account2 [email protected] Code1 Account2 Code1
Account3 [email protected] Code3 Account3 Code3
Account4 ][email protected] Code4 Account4 Code4
Account 5 [email protected] Code5 Account 5 Code5
Account6 [email protected] Code6 Account6 Code6
Account6 [email protected] FALSE Account7 Code7
Account6 [email protected] FALSE Account8 Code8
Account7 [email protected] FALSE Account9 Code9
Account7 [email protected] FALSE Account10 Code10
Account7 [email protected] FALSE Account11 Code11

I attempted to use the following formula...

=if(A2=D2,E)
now it will go down as far as the last line that matches directly across from it, but anything like that just says FALSE...