Anbuselvam K
Member
Hi,
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 lookup value in our formulation.
Can anyone guide me to get the result?
Thanks in Advance!
AB11 00-Jan-1900
Sl. No Date Product Batch Number Qty
1 19-Mar-15 Product1 AB11 10
2 19-Mar-15 Product1 AB11 10
3 21-Mar-15 Product1 AB13 10
4 22-Mar-15 Product2 AB14 10
5 23-Mar-15 Product2 AB15 10
6 24-Mar-15 Product2 AB16 10
7 25-Apr-15 Product2 AB17 10
8 26-Apr-15 Product3 AB18 10
9 27-Apr-15 Product3 AB19 10
10 28-Apr-15 Product3 AB20 10
11 29-Apr-15 Product3 AB21 10
12 10-May-15 Product4 AB22 10
13 11-May-15 Product4 AB23 10
14 12-May-15 Product4 AB24 10
15 13-May-15 Product4 AB25 10
16 14-May-15 Product4 AB26 10
17 15-May-15 Product4 AB27 10
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 lookup value in our formulation.
Can anyone guide me to get the result?
Thanks in Advance!
AB11 00-Jan-1900
Sl. No Date Product Batch Number Qty
1 19-Mar-15 Product1 AB11 10
2 19-Mar-15 Product1 AB11 10
3 21-Mar-15 Product1 AB13 10
4 22-Mar-15 Product2 AB14 10
5 23-Mar-15 Product2 AB15 10
6 24-Mar-15 Product2 AB16 10
7 25-Apr-15 Product2 AB17 10
8 26-Apr-15 Product3 AB18 10
9 27-Apr-15 Product3 AB19 10
10 28-Apr-15 Product3 AB20 10
11 29-Apr-15 Product3 AB21 10
12 10-May-15 Product4 AB22 10
13 11-May-15 Product4 AB23 10
14 12-May-15 Product4 AB24 10
15 13-May-15 Product4 AB25 10
16 14-May-15 Product4 AB26 10
17 15-May-15 Product4 AB27 10