Need to compare 2 lists and return the date if different

Hi all,

First post ever here so I hope the formatting comes out clear. I think it will truncate spaces so this might help or see the attached file.

Column A = numbers or text combinations
Column B = date
Column C = time
Column D = mystery formula goes here
Column E = numbers or text combinations
Column F = date
Column G = time

I wish to see if any cell in Column (A) is also found in Column (E) and if it is return the date of Column (F) from List 2 to the (D) cell for the line item searched.

____LIST 1_____ _____LIST 2_____
A B C D E F G
1 NUMBER_TEXT 2/4/2009 9:04:44 AM " NUMBER 5/20/2015 11:14:17 AM
2 NUMBER 11/16/2011 2:25:54 PM IF A2 IS FOUND IN THE E COLUMN, ENTER F2 HERE TEXT 9/25/2007 9:59:46 AM
3 TEXT 9/25/2007 9:59:46 AM " TEXTNUMBER 9/1/2014 3:23:40 AM
4 TEXTNUMBER 1/27/2014 4:08:29 PM 9/1/2014 (Example result)

Thanks for your quick replies!
FDibbins, that solution didn't just work, I think it needs a little tweaking to work.
nflsales, that solution did work the first time.

I'm impressed with what the experts here know about Excel. I try to self educate myself and some of this is really hard. Thanks for your help!