VBA - Vlook up function not picking all values

Guys, I have 2 workbooks
I am trying to put vlook on the first book for the range which is present in second workbook
First sheet named is macro
second sheet named is BANKNIFTYWK29800CE
so basically I want column G column of second sheet to come to first sheet on E column. for this first I joined date and time in both the sheets and then used vlookup.
Vlook up is working fine till 1069 row. after this its giving me 0.05 value and after 1505 , its totally blank.

I want vlookup to ignore the cell ( leave it blank) if the look up item is not there.

I am attaching here both the workbooks.

Thanks a lot guys