How to get Previous Date from Table 2 for Max Date in Table 1

[rammuthiah]

Here I have one logic that needs to be done as given in the below excel output. Can anyone help me out in this logic?

            

Output Table Should be

[sunny_talwar]

I went through you logic above and also tried to look at the new sample, but I am not sure what exactly are you looking to get and how you are looking to get it. May be someone else can offer help here

[rammuthiah]

Thanks for responding patiently, Sunny.
If the SD value present in Table1, then it should not show PL value from Table 2. For instance,
Use        Row 1-> 1, Ax, 30-08-2017, 2,1(SD) ------ Table 1
Use        Row 1->  1, Ax, 30-07-2017, 2,1(PL) ------ Table 2
Use        Row 2->  1, Ax, 30-07-2017, 2,2(PL) ------ Table 2

Output : Should be one row - 1, Ax, 30-07-2017, 2,1(SD) ----- Result (SD Value =1, no need of looking for PL value 1 or 2, if SD value is not present in Table 1, then show PL value from Table 2)

For me it is showing as 1, Ax, 30-07-2017, 2,1 ----T1
                                  1, Ax, 30-07-2017, 2,1 ----T2
                                  1, Ax, 30-07-2017, 2,2 ----T2