First of all thank you I appreciate you taking the time to do this, I'm very thankful. The formula some what works, but if you can explain to me how this formula work especially the index part I could fix it up my self.
=IFERROR(N(INDEX(Sheet2!$C$1:$C$1000,MATCH(1,INDEX(--(Sheet2!$A$1:$A$1000&""=Sheet1!$A2&"")*--(Sheet2!$B$1:$B$1000>=DATE(2012,6,1)),0),0))),"-")
Thank You once again!!!!!!