Combining Vlookup + If with > <

Hi I wonder if anyone can help me

I am trying to create a formula that would fill in column D and E in sheet one with the following information:

If the part number in sheet 1 the same as in sheet 2, please fill in Column D (in sheet 1) with the earliest date (in sheet 2) after the date column G (sheet 1) from Sheet 2

Is that confusing or what , sorry

I have attached a sample of the file

Thanks

Tay

In D2 (Sheet1) maybe,

=MIN(IF((Sheet2!$A$2:$A$15=Sheet1!$A2)*(Sheet2!$C$2:$C$15>Sheet1!$H2),Sheet2!C$2:C$15))

Array formula, confirm by Ctrl+Shift+Enter

Is that correctly understood for the first part?

Hi Berlan,

Thanks for your reply. With your formula the result is showing 18/05/2015, its should be 26/05/2015 and 08:08:01 for the time. As this is the next date and time after Column H and 1 in sheet 1 = (26/05/2015 07:05:50)


Tay