Need Start date of term (Example a policy effective to policy Expiration date) by finding

Hi, I need help from all the experts who can help me.
I have a situation wherein 2 lists of data as following:

Sheet 1 - Contains a Unique Policy number list which will have multiple lines repeating but with different transaction dates (which are basically a date a person entered who is maintaing daily enteries for purchases).

Sheet 2- Contains a the same kind of Unique (policy#) number however has Policy Term dates (Every year a new policy is renewed for these unique numbers.

What I need is I need to do is find the Term Start date and Expiration date for each Unique Policy date on Sheet 1 by comparing whether the Transaction date falls in which Term of that Unique Policy from Sheet 2.

Note: A unique policy might have multiple Terms so we will have look first with the Policy# and then try to find whether my Transaction date falls in which Unique Policy numbes term and provide me the Start Date in a cell besides Transaction date and Expiration date of term besides the Start date of Term.

Friends please help me out with this.

Hi,

I have attached sample file.

the file is made in excel 2010 version