Spreadsheet: 872488d1718862471-conditional-formatting-with-vlookup-find-missing-values-formula-typing-error-sheetbg
Sheet: FR

Sr. No. | Container id | [NAME] | Decision Logic | Unit | Kilometers
 | 8801010883 | 8088570125 | DRP208 | 2
 | 8801010577 | 8088009280 | DRP208 | 2
29 | 8801010189 | 8088508572 | DRP208 | 2
77 | 810121021 | 8081000008 | DRP208 | 2
82 | 8801010503 | 8088000235 | DRP208 | 2
59 | 8301017009 | 2023503097 | CTY223 | 2
97 | 8301017015 | 2023503713 | CTY223 | 2
35 | 8801010208 | 8088370895 | CTY223 | 2
98 | 8801010385 | 8088510391 | CTY223 | 2
89 | 8801010991 | 8088009788 | CTY223 | 2
102 | 810101779 | 8081772701 | CTY223 | 2
53 | 8801010882 | 8088587758 | BYT223 | 2
87 | 8801010558 | 8088777888 | CAL201 | 1 | 8050
109 | 8801010783 | 8088518878 | CAL201 | 1 | 8050
 | 8801010181 | 8088317779 | CBT201 | 7 | 9089
 | 8801010752 | 8088817977 | CCP201 | 1 | 9858
 | 8801010895 | 8088008037 | CIP302 | 1 | 7508
18 | 8801010178 | 8088758095 | Csa021 | 3 | 10021
91 | 810101299 | 8081709215 | CSA021 | 3 | 10021
32 | 8801010205 | 8088773795 | CSA021 | 3 | 10021
80 | 8801010583 | 8088009327 | CSA021 | 3 | 10021
100 | 810101779 | 8081772701 | CSA021 | 3 | 10021
58 | 810101217 | 8081377587 | CSA201 | 3 | 10021
12 | 8801010838 | 8088007297 | CSA202 | 3 | 8050
11 | 8801010838 | 8088007297 | CSA203 | 3 | 9775
 | 810101088 | 8081755219 | CSC011 | 3 | 8879
 | 810101771 | 8081001811 | CSC011 | 3 | 8879
 | 8801010883 | 8088570125 | CSC202 | 3 | 8702
77 | 8801010825 | 8088733389 | DSE012 | 3 | 7500
55 | 810101223 | 8081777778 | DSE012 | 3 | 7500
75 | 810101172 | 8081388192 | DSE017 | 2 | 8185
2 | 8801010179 | 8088718571 | DSE017 | 2 | 8185
20 | 8801010985 | 8088785153 | DSE017 | 2 | 8185
77 | 8801010733 | 8088782789 | DSE017 | 2 | 8185
58 | 8801010332 | 8088007755 | DSE017 | 2 | 8185
73 | 810101199 | 8081380807 | DSE117 | 3 | 7812
57 | 8301017009 | 2023503097 | [NAME] | 3 | 5937
95 | 8301017015 | 2023503713 | [NAME] | 3 | 5937
17 | 8801010121 | 8088009308 | [NAME] | 3 | 5937
72 | 8801010811 | 8088839191 | [NAME] | 3 | 5937
10 | 8801010078 | 8088738077 | [NAME] | 3 | 5937
52 | 8801010771 | 8088383359 | [NAME] | 3 | 5937
 | 8801010870 | 8088008190 | [NAME] | 3 | 5937
 | 8801010327 | 8088379528 | [NAME] | 3 | 5937
 | 8801010181 | 8088317779 | [NAME] | 3 | 5937
 | 8801010373 | 8088351987 | [NAME] | 3 | 5937
 | 8801010787 | 8088009732 | [NAME] | 3 | 5937
7 | 8801010855 | 8088007991 | [NAME] | 7 | 5937
28 | 8801010812 | 8088839782 | [NAME] | 3 | 5937
38 | 8801010208 | 8088370895 | [NAME] | 3credit | 5937
57 | 8801010882 | 8088587758 | [NAME] | 3 | 5937
97 | 8801010385 | 8088510391 | [NAME] | 3 | 5937
81 | 8801010919 | 8088512773 | DSE275 | 7 credits | 8031
 | 8801010787 | 8088009732 | DSE275 | 7 | 8031
73 | 8801010811 | 8088839191 | DSE275 | 7 | 8031
5 | 8801010382 | 8088570899 | DSE275 | 7 | 8031
9 | 8801010078 | 8088738077 | DSE275 | 7 | 8031
13 | 8801010720 | 8088005093 | DSE275 | 7 | 8031
33 | 8801010381 | 8088811372 | DSE275 | 7 | 8031
51 | 8801010771 | 8088383359 | DSE275 | 7 | 8031
 | 8801010870 | 8088008190 | DSE275 | 7 | 8031
 | 8801010888 | 8088837222 | DSE275 | 7 | 8031
 | 8801010181 | 8088317779 | DSE275 | 7 | 8031
 | 8801010787 | 8088009732 | DSE275 | 2 | 8031
107 | 8801010797 | 8088787153 | DSE275 | 7 | 8031
 | 8801010881 | 8088583798 | DSE275 | 7 | 8031
58 | 8301017009 | 2023503097 | [NAME] | 3 | 3311
97 | 8301017015 | 2023503713 | [NAME] | 3 | 3311
80 | 8801010852 | 8088903518 | [NAME] | 3 | 3311
20 | 8801010178 | 8088758095 | [NAME] | 3 credit | 3311
82 | 8801010919 | 8088512773 | [NAME] | 3 credits | 3311
77 | 8801010811 | 8088839191 | [NAME] | 3 | 3311
37 | 8801010381 | 8088811372 | [NAME] | 3 | 3311
 | 8801010870 | 8088008190 | [NAME] | 3 | 3311
 | 8801010181 | 8088317779 | [NAME] | 3 | 3311
 | 8801010787 | 8088009732 | [NAME] | 3 | 3311
5 | 8801010855 | 8088007991 | [NAME] | 7 | 3311
55 | 8801010882 | 8088587758 | [NAME] | 3 | 3311
57 | 8801010297 | 8088527313 | [NAME] | 3 CREDIT | 3311
105 | 8801010797 | 8088787153 | [NAME] | 3 | 3311
 | 8801010852 | 8088903518 | DSE278 | 3 | 8793
3 | 8801010855 | 8088007991 | DSE278 | 3 | 8793
83 | 8801010571 | 8088502123 | DSE278 | 3 | 8793
17 | 8801010838 | 8088007297 | DSE278 | 3 | 8793
8 | 8801010078 | 8088738077 | DSE278 | 3 | 8793
17 | 8801010720 | 8088005093 | DSE278 | 3 | 8793
21 | 8801010985 | 8088785153 | DSE278 | 3 | 8793
73 | 8801010733 | 8088782789 | DSE278 | 3 | 8793
53 | 8801010771 | 8088383359 | DSE278 | 3 | 8793
78 | 8801010755 | 8088380387 | DSE278 | 3 | 8793
 | 8801010883 | 8088570125 | DSE278 | 3 | 8793
 | 8801010270 | 8088788190 | DSE278 | 3 | 8793
 | 8801010752 | 8088817977 | DSE278 | 3 | 8793
 | 8801010218 | 8088590779 | DSE278 | 3 | 8793
 | 8801010373 | 8088351987 | DSE278 | 3 | 8793
 | 8801010577 | 8088009280 | DSE278 | 3 | 8793
 | 8801010778 | 8088532875 | DSE278 | 3 | 8793
33 | 8801010205 | 8088773795 | DSE278 | 3 | 8793
39 | 8801010208 | 8088370895 | DSE278 | 3 credit | 8793
51 | 810121021 | 8081000008 | DSE278 | 3 credit | 8793
59 | 8801010297 | 8088527313 | DSE278 | 3 credit | 8793
99 | 8801010385 | 8088510391 | DSE278 | 3 | 8793
75 | 8801010755 | 8088380387 | DSE278 | 3 | 8793
79 | 8801010503 | 8088000235 | DSE278 | 3 | 8793
88 | 810101779 | 8081772701 | DSE278 | 3 | 8793
103 | 8801010778 | 8088532875 | DSE278 | 3 | 8793
 | 8801010881 | 8088583798 | DSE278 | 3 | 8793
18 | 8801010178 | 8088758095 | DSE250 | 7 credit | 8175
13 | 8801010838 | 8088007297 | DSE250 | 7 | 8175
 | 8801010752 | 8088817977 | DSE250 | 7 | 8175
37 | 8801010205 | 8088773795 | DSE250 | 7 | 8175
95 | 8801010385 | 8088510391 | DSE250 | 7 | 8175
88 | 810101779 | 8081772701 | DSE250 | 7 | 8175
31 | 8801010718 | 8088005558 | DSE251 | 7 | 8813
32 | 8801010381 | 8088811372 | DSE251 | 7 | 8813
50 | 8801010771 | 8088383359 | DSE251 | 7 | 8813
77 | 8801010503 | 8088000235 | DSE251 | 7 | 8813
 | 8801010881 | 8088583798 | DSE251 | 7 | 8813
15 | 8801010838 | 8088007297 | DSE252 | 3 | 8005
7 | 8801010078 | 8088738077 | DSE252 | 3 | 8005
55 | 8801010115 | 8088005228 | DSE252 | 3 | 8005
 | 8801010511 | 8088313171 | DSE252 | 3 | 8005
 | 8801010270 | 8088788190 | DSE252 | 2 | 8005
 | 8801010773 | 8088787297 | DSE252 | 3 | 8005
 | 8801010787 | 8088009732 | DSE252 | 3 | 8005
50 | 810121021 | 8081000008 | DSE252 | 3 Credit | 8005
101 | 810101779 | 8081772701 | DSE252 | 3 | 8005
92 | 8301017009 | 2023503097 | DSE253 | 2 | 511
70 | 8301017015 | 2023503713 | DSE253 | 2 | 511
83 | 8801010027 | 8088007391 | DSE253 | 2 | 511
81 | 8801010852 | 8088903518 | DSE253 | 2 | 511
85 | 8801010507 | 8088789392 | DSE253 | 2 | 511
35 | 8801010381 | 8088811372 | DSE253 | 2 | 511
79 | 8801010597 | 8088309733 | DSE253 | 2 | 511
 | 8801010710 | 8088703297 | DSE253 | 2 | 511
 | 8801010981 | 8088009805 | DSE253 | 2 | 511
90 | 8301017009 | 2023503097 | DSE257 | 2 | 7701
98 | 8301017015 | 2023503713 | DSE257 | 2 | 7701
98 | 8101137007 | 8081398195 | DSE257 | 2 Credits | 7701
75 | 8801010811 | 8088839191 | DSE257 | 2 | 7701
8 | 8801010078 | 8088738077 | DSE257 | 2 | 7701
 | 8801010895 | 8088008037 | DSE257 | 2 | 7701
 | 8801010373 | 8088351987 | DSE257 | 2 | 7701
 | 8801010981 | 8088009805 | DSE257 | 2 | 7701
 | 8801010577 | 8088009280 | DSE257 | 2 | 7701
30 | 8801010812 | 8088839782 | DSE257 | 2 | 7701
38 | 8801010208 | 8088370895 | DSE257 | 2 credit | 7701
52 | 810121021 | 8081000008 | DSE257 | 2 credit | 7701
 | 8801010895 | 8088008037 | CSI012 | 2 | 7508
 | 8801010893 | 8088007731 | Csi012 | 2 | 7508
72 | 8801010713 | 8088832103 | DSP017 | 1 credit | 8597
79 | 810101172 | 8081388192 | DSP017 | 1 | 8597
3 | 8801010179 | 8088718571 | DSP017 | 1 | 8597
29 | 8801010732 | 8088713398 | DSP017 | 1 | 8597
28 | 810101150 | 8081371738 | DSP017 | 1 | 8597
70 | 8801010208 | 8088370895 | DSP017 | 1credit | 8597
78 | 810121021 | 8081000008 | DSP017 | 1 credit | 8597
80 | 8801010503 | 8088000235 | DSP017 | 1 | 8597
88 | 810101383 | 8081300973 | DSP017 | 1 | 8597
 | 8801010818 | 8088805827 | DSP113 |  | 7812
 | 8801010787 | 8088009732 | DSP113 | 1 | 7812
92 | 8801010385 | 8088510391 | DSP119 | 2 | 8919
58 | 8301017009 | 2023503097 | DSP272 | 1 | 8888
99 | 8301017015 | 2023503713 | DSP272 | 1 | 8888
81 | 8801010027 | 8088007391 | DSP272 | 1 | 8888
82 | 8801010852 | 8088903518 | DSP272 | 1 | 8888
38 | 8801010238 | 8088307891 | DSP272 | 1 | 8888
 | 8801010710 | 8088703297 | DSP272 | 1 | 8888
 | 8801010895 | 8088008037 | DSP272 | 1 | 8888
10 | 8801010855 | 8088007991 | DSP272 | 1 | 8888
19 | 8801010107 | 8088588100 | DSP272 | 1 | 8888
25 | 8801010881 | 8088555807 | DSP272 | 1 | 8888
97 | 8801010385 | 8088510391 | DSP272 | 1 | 8888
93 | 8301017009 | 2023503097 | DSP273 | 1 | 8919
71 | 8301017015 | 2023503713 | DSP273 | 1 | 8919
82 | 8801010027 | 8088007391 | DSP273 | 1 | 8919
37 | 8801010381 | 8088811372 | DSP273 | 1 | 8919
75 | 8801010771 | 8088757752 | DSP273 | 1 | 8919
88 | 8801010558 | 8088777888 | DSP273 | 1 | 8919
91 | 8301017009 | 2023503097 | DSP277 | 1 | 8588
98 | 8301017015 | 2023503713 | DSP277 | 1 | 8588
71 | 8801010713 | 8088832103 | DSP277 | 1 credit | 8588
77 | 8801010811 | 8088839191 | DSP277 | 1 | 8588
12 | 8801010930 | 8088007982 | DSP277 | 1 | 8588
15 | 8801010720 | 8088005093 | DSP277 | 1 | 8588
39 | 8801010381 | 8088811372 | DSP277 | 1 | 8588
38 | 8801010918 | 8088000788 | DSP277 | 1 | 8588
 | 8801010898 | 8088008129 | DSP277 | 1 | 8588
 | 8801010218 | 8088590779 | DSP277 | 1 | 8588
8 | 8801010855 | 8088007991 | DSP277 | 1 | 8588
31 | 8801010812 | 8088839782 | DSP277 | 1 | 8588
87 | 8801010977 | 8088357810 | DSP277 | 1 | 8588
73 | 8801010713 | 8088832103 | DSP278 | 1 credit | 9775
87 | 8801010571 | 8088502123 | DSP278 | 1 credit | 9775
18 | 8801010720 | 8088005093 | DSP278 | 1 | 9775
22 | 8801010985 | 8088785153 | DSP278 | 1 | 9775
78 | 8801010825 | 8088733389 | DSP278 | 1 | 9775
 | 8801010511 | 8088313171 | DSP278 | 1 | 9775
 | 8801070028 | 8088003771 | DSP278 | 1 | 9775
 | 8801010707 | 8088009109 | DSP278 | 1 | 9775
8 | 8801010855 | 8088007991 | DSP278 | 1 | 9775
71 | 8801010208 | 8088370895 | DSP278 | 1credit | 9775
78 | 810121021 | 8081000008 | DSP278 | 1 credit | 9775
81 | 8801010503 | 8088000235 | DSP278 | 1 | 9775
83 | 8801010933 | 8088009712 | DSP278 | 1 | 9775
89 | 8801010087 | 8088005817 | [NAME] | 1 | 7717
 | 8801010855 | 8088918109 | [NAME] | 1 | 7717
 | 8801010258 | 8088385885 | [NAME] | 1 | 7717
 | 8801010707 | 8088009109 | [NAME] | 1 | 7717
21 | 8801010178 | 8088758095 | [NAME] | 1 credit | 7717
27 | 8801010189 | 8088508572 | [NAME] | 1 | 7717
22 | 8801010178 | 8088758095 | DSP252 | 1 credit | 8828
77 | 8801010713 | 8088832103 | DSP252 | 1 credit | 8828
17 | 8801010720 | 8088005093 | DSP252 | 1 | 8828
23 | 8801010985 | 8088785153 | DSP252 | 1 | 8828
78 | 8801010825 | 8088733389 | DSP252 | 1 | 8828
57 | 8801010115 | 8088005228 | DSP252 | 1 | 8828
 | 8801010258 | 8088385885 | DSP252 | 1 | 8828
 | 8801010707 | 8088009109 | DSP252 | 1 | 8828
1 | 8801010037 | 8088525892 | DSP252 | 1 | 8828
80 | 8801010027 | 8088007391 | DSP257 | 2 | 7893
83 | 8801010852 | 8088903518 | DSP257 | 2 | 7893
79 | 8801010811 | 8088839191 | DSP257 | 2 | 7893
19 | 8801010720 | 8088005093 | DSP257 | 2 | 7893
18 | 8801010980 | 8088509907 | DSP257 | 2 | 7893
 | 8801010927 | 8088508175 | DSP257 | 2 | 7893
 | 8801010270 | 8088788190 | DSP257 | 2 | 7893
 | 8801010019 | 8088009231 | DSP257 | 2 | 7893
2 | 8801010037 | 8088525892 | DSP257 | 2 | 7893
9 | 8801010855 | 8088007991 | DSP257 | 2 | 7893
23 | 8801010830 | 8088509228 | DSP257 | 2 | 7893
90 | 8801010337 | 8088777958 | DSP257 | 2 | 7893
78 | 8801010503 | 8088000235 | DSP257 | 2 | 7893
89 | 8801010557 | 8088797782 | DSP257 | 2 | 7893
70 | 8801010713 | 8088832103 | DSP287 | 2 credits | 8708
7 | 8801010180 | 8088003287 | DSP287 | 2 | 8708
27 | 8801010985 | 8088785153 | DSP287 | 2 | 8708
27 | 8801010732 | 8088713398 | DSP287 | 1 | 8708
70 | 8801010238 | 8088307891 | DSP287 | 2 | 8708
87 | 8801010087 | 8088005817 | DSP287 | 2 | 8708
 | 8801010883 | 8088570125 | DSP287 | 2 | 8708
 | 8801010232 | 8088707180 | DSP287 | 2 | 8708
 | 8801010270 | 8088788190 | DSP287 | 2 | 8708
 | 8801010258 | 8088385885 | DSP287 | 2 | 8708
7 | 8801010855 | 8088007991 | DSP287 | 2 | 8708
37 | 8801010208 | 8088370895 | DSP287 | 2credit | 8708
78 | 8801010503 | 8088000235 | DSP287 | 2 | 8708
 | 8801010290 | 8088552129 | EEE MOO207 | 2 | 8793
93 | 8801010385 | 8088510391 | EEP112 | 1
 |  |  | Add new
85 | 8801010977 | 8088357810 | EEP112 | 1
 | 8801010981 | 8088009805 | JED001 | 2 | 5999
 | 8801010895 | 8088008037 | JED001 | 2 | 5999
1 | 8801010911 | 8088727339 | JED001 | 2 | 5999
25 | 8801010985 | 8088785153 | JED001 | 2 | 5999
28 | 8801010732 | 8088713398 | JED001 | 2 | 5999
28 | 8801010178 | 8088325232 | JED001 | 2 | 5999
30 | 8801010719 | 8088503088 | JED001 | 2 | 5999
71 | 8801010238 | 8088307891 | JED001 | 2 | 5999
87 | 8801010853 | 8088903888 | JED001 | 2 | 5999
 | 8801010927 | 8088508175 | JED001 | 2 | 5999
 | 8801010218 | 8088590779 | JED001 | 2 | 5999
27 | 8801010830 | 8088509228 | JED001 | 2 | 5999
85 | 8801010571 | 8088502123 | JED001 | 2 | 5999
88 | 8801010087 | 8088005817 | MEP105 | 1.5
 | 8801010893 | 8088007731 | MTH172 | 7
 | 8801010981 | 8088009805 | MTH172 | 7
77 | 810101172 | 8081388192 | MTH175 | 7
78 | 810101058 | 8081301833 | MTH175 | 7
 | 8801010893 | 8088007731 | ONB703 | 2 | 8338
87 | 8801010991 | 8088009788 | ONB703 | 2 | 8338
88 | 8801010087 | 8088005817 | PHYI92 | 1