Spreadsheet: 824120d1680311502-to-find-defect-and-description-using-vlookup-sample
Sheet: MLTrainFaultReport

S/ No | Date | Sub Sys. | Operation Status | [NAME] (min) | Investigation   Findings: | Reference No | JR No | Action Taken | WO ID | Defects | Defect Code | Defect Description
1 | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  | EMU/TB3
2 | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  | Unknown
3 | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  | EMU/TI3
4 | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  | EMU/DR10
5 | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  | EMU/TB1
6 | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  | EMU/LV2
7 | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  | EMU/PIS7
8 | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  | EMU/BO8
9 | 2020-01-02 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
10 | 2020-01-02 00:00:00 |  |  |  |  |  |  |  |  | EMU/CA1
11 | 2020-01-02 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
12 | 2020-01-02 00:00:00 |  |  |  |  |  |  |  |  | EMU/TB8
13 | 2020-01-02 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
14 | 2020-01-02 00:00:00 |  |  |  |  |  |  |  |  | EMU/LV14
15 | 2020-01-03 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
16 | 2020-01-03 00:00:00 |  |  |  |  |  |  |  |  | EMU/DR10
17 | 2020-01-03 00:00:00 |  |  |  |  |  |  |  |  | EMU/BO15
18 | 2020-01-04 00:00:00 |  |  |  |  |  |  |  |  | Unknown
19 | 2020-01-04 00:00:00 |  |  |  |  |  |  |  |  | EMU/TI7
20 | 2020-01-04 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
21 | 2020-01-04 00:00:00 |  |  |  |  |  |  |  |  | EMU/CA10
22 | 2020-01-04 00:00:00 |  |  |  |  |  |  |  |  | EMU/COM10
23 | 2020-01-04 00:00:00 |  |  |  |  |  |  |  |  | EMU/TB3
24 | 2020-01-05 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
25 | 2020-01-05 00:00:00 |  |  |  |  |  |  |  |  | Unknown
26 | 2020-01-05 00:00:00 |  |  |  |  |  |  |  |  | EMU/PIS7
27 | 2020-01-05 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
28 | 2020-01-05 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
29 | 2020-01-06 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
30 | 2020-01-06 00:00:00 |  |  |  |  |  |  |  |  | EMU/DR10
31 | 2020-01-06 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
32 | 2020-01-06 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
33 | 2020-01-06 00:00:00 |  |  |  |  |  |  |  |  | EMU/PIS7
34 | 2020-01-06 00:00:00 |  |  |  |  |  |  |  |  | Unknown
35 | 2020-01-07 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
36 | 2020-01-07 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
37 | 2020-01-07 00:00:00 |  |  |  |  |  |  |  |  | EMU/DM4
38 | 2020-01-07 00:00:00 |  |  |  |  |  |  |  |  | EMU/TB16
39 | 2020-01-07 00:00:00 |  |  |  |  |  |  |  |  | EMU/PIS8
40 | 2020-01-07 00:00:00 |  |  |  |  |  |  |  |  | EMU/DR1
41 | 2020-01-08 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
42 | 2020-01-08 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
43 | 2020-01-08 00:00:00 |  |  |  |  |  |  |  |  | EMU/LV10
44 | 2020-01-08 00:00:00 |  |  |  |  |  |  |  |  | EMU/DR4
45 | 2020-01-08 00:00:00 |  |  |  |  |  |  |  |  | EMU/LT1
46 | 2020-01-09 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
47 | 2020-01-09 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
48 | 2020-01-09 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
49 | 2020-01-09 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
50 | 2020-01-09 00:00:00 |  |  |  |  |  |  |  |  | EMU/BD20
51 | 2020-01-09 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
52 | 2020-01-09 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
53 | 2020-01-10 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
54 | 2020-01-10 00:00:00 |  |  |  |  |  |  |  |  | Unknown
55 | 2020-01-10 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
56 | 2020-01-10 00:00:00 |  |  |  |  |  |  |  |  | EMU/CA10
57 | 2020-01-10 00:00:00 |  |  |  |  |  |  |  |  | EMU/LT1
58 | 2020-01-10 00:00:00 |  |  |  |  |  |  |  |  | Unknown
59 | 2020-01-10 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
60 | 2020-01-11 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
61 | 2020-01-11 00:00:00 |  |  |  |  |  |  |  |  | Unknown
62 | 2020-01-11 00:00:00 |  |  |  |  |  |  |  |  | Unknown
63 | 2020-01-11 00:00:00 |  |  |  |  |  |  |  |  | EMU/CA6
64 | 2020-01-11 00:00:00 |  |  |  |  |  |  |  |  | EMU/TB17
65 | 2020-01-11 00:00:00 |  |  |  |  |  |  |  |  | Unknown
66 | 2020-01-11 00:00:00 |  |  |  |  |  |  |  |  | Unknown
67 | 2020-01-11 00:00:00 |  |  |  |  |  |  |  |  | Unknown
68 | 2020-01-12 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
69 | 2020-01-12 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
70 | 2020-01-12 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
71 | 2020-01-12 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
72 | 2020-01-12 00:00:00 |  |  |  |  |  |  |  |  | Unknown
73 | 2020-01-12 00:00:00 |  |  |  |  |  |  |  |  | Unknown
74 | 2020-01-12 00:00:00 |  |  |  |  |  |  |  |  | Unknown
75 | 2020-01-12 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
76 | 2020-01-13 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
77 | 2020-01-13 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
78 | 2020-01-13 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
79 | 2020-01-13 00:00:00 |  |  |  |  |  |  |  |  | Unknown
80 | 2020-01-13 00:00:00 |  |  |  |  |  |  |  |  | EMU/CA11
81 | 2020-01-14 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
82 | 2020-01-14 00:00:00 |  |  |  |  |  |  |  |  | EMU/TB16
83 | 2020-01-14 00:00:00 |  |  |  |  |  |  |  |  | EMU/BO9
84 | 2020-01-14 00:00:00 |  |  |  |  |  |  |  |  | EMU/PIS8
85 | 2020-01-14 00:00:00 |  |  |  |  |  |  |  |  | EMU/DM4
86 | 2020-01-14 00:00:00 |  |  |  |  |  |  |  |  | EMU/LT1
87 | 2020-01-14 00:00:00 |  |  |  |  |  |  |  |  | EMU/CA15
88 | 2020-01-14 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
89 | 2020-01-14 00:00:00 |  |  |  |  |  |  |  |  | Unknown
90 | 2020-01-14 00:00:00 |  |  |  |  |  |  |  |  | EMU/PIS7
91 | 2020-01-14 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
92 | 2020-01-14 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
93 | 2020-01-15 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
94 | 2020-01-15 00:00:00 |  |  |  |  |  |  |  |  | Unknown
95 | 2020-01-15 00:00:00 |  |  |  |  |  |  |  |  | Unknown
96 | 2020-01-15 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
97 | 2020-01-15 00:00:00 |  |  |  |  |  |  |  |  | EMU/TB19
98 | 2020-01-15 00:00:00 |  |  |  |  |  |  |  |  | EMU/LT1
99 | 2020-01-15 00:00:00 |  |  |  |  |  |  |  |  | EMU/FS1
100 | 2020-01-15 00:00:00 |  |  |  |  |  |  |  |  | EMU/DM1
101 | 2020-01-15 00:00:00 |  |  |  |  |  |  |  |  | EMU/TI7
102 | 2020-01-15 00:00:00 |  |  |  |  |  |  |  |  | EMU/BD11
103 | 2020-01-15 00:00:00 |  |  |  |  |  |  |  |  | Fault Referred to A
104 | 2020-01-15 00:00:00 |  |  |  |  |  |  |  |  | Unknown
105 | 2020-01-16 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
106 | 2020-01-16 00:00:00 |  |  |  |  |  |  |  |  | [NAME]