As per the below data, D column Batch Number and B column Date. by using the formulation in B, B1 '=TEXT(VLOOKUP(A1,A:E,2,1),"dd-mmm-yyyy") then the result is
00-Jan-1900. But my expected result is 19-Mar-15.
Note that in column D Batch Number two cells have a same value which is the...