Identify the value in worksheet one and define the same in worksheet 2

I need a formula or function ( Vlookup) to match two columns in two different worksheets in excel and if value found in worksheet 1 after the perticular date of worksheet 2 than value will be shown in worksheet 2