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 Emailaddress@address.com Code1 Account1 Code1
Account2 Emailaddress@address.com Code1 Account2 Code1
Account3 Emailaddress@address.com Code3 Account3 Code3
Account4 ]Emailaddress@address.com Code4 Account4 Code4
Account 5 Emailaddress@address.com Code5 Account 5 Code5
Account6 Emailaddress@address.com Code6 Account6 Code6
Account6 Emailaddress@address.com FALSE Account7 Code7
Account6 Emailaddress@address.com FALSE Account8 Code8
Account7 Emailaddress@address.com FALSE Account9 Code9
Account7 Emailaddress@address.com FALSE Account10 Code10
Account7 Emailaddress@address.com 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...