Spreadsheet: 872486d1718862443-conditional-formatting-with-vlookup-find-missing-values-formula-typing-error-sheetac
Sheet: sales data to search

Sr. No. | Container id | [NAME] | Decision Logic | Unit | Kilometers
1 | 8801010883 | 8088570125 | DRP208 | 2 | 8828
2 | 8801010577 | 8088009280 | DRP208 | 2 | 8828
3 | 8801010189 | 8088508572 | DRP208 | 2 | 8828
7 | 810121021 | 8081000008 | DRP208 | 2 | 8828
5 | 8801010503 | 8088000235 | DRP210 | 2 | 8828
9 | 8301017009 | 8083503097 | CTY223 | 2 | 8938
7 | 8301017015 | 8083503713 | CTY223 | 2 | 8938
8 | 8801010208 | 8088370895 | CTY223 | 2 | 8938
8 | 8801010385 | 8088510391 | CTY223 | 2 | 8938
10 | 8801010991 | 8088009788 | CTY223 | 2 | 8938
11 | 810101779 | 8081772701 | CTY223 | 2 | 8938
12 | 8801010882 | 8088587758 | BYT223 | 2 | 8938
13 | 8801010558 | 8088777888 | CAL201 | 1 | 8050
17 | 8801010783 | 8088518878 | CAL201 | 1 | 8050
15 | 8801010181 | 8088317779 | CBT201 | 7 | 9089
19 | 8801010752 | 8088817977 | CCP201 | 1 | 9858
17 | 8801010895 | 8088008037 | CIP302 | 1 | 7508
18 | 8801010178 | 8088758095 | CSA021 | 3 | 8031
18 | 810101299 | 8081709215 | CSA021 | 3 | 8031
20 | 8801010205 | 8088773795 | CSA021 | 3 | 8031
21 | 8801010583 | 8088009327 | CSA021 | 3 | 8031
22 | 810101779 | 8081772701 | CSA021 | 3 | 8031
23 | 810101217 | 8081377587 | CSA201 | 3 | 8031
27 | 8801010838 | 8088007297 | CSA202 | 3 | 8050
25 | 8801010838 | 8088007297 | CSA203 | 3 | 9775
29 | 810101088 | 8081755219 | CSC011 | 3 | 8879
27 | 810101771 | 8081001811 | CSC011 | 3 | 8879
28 | 8801010883 | 8088570125 | CSC202 | 3 | 8702
28 | 8801010825 | 8088733389 | DSE012 | 3 | 7500
30 | 810101223 | 8081777778 | DSE012 | 3 | 7500
31 | 810101172 | 8081388192 | DSE017 | 2 | 8185
32 | 8801010179 | 8088718571 | DSE017 | 2 | 8185
33 | 8801010985 | 8088785153 | DSE017 | 2 | 8185
37 | 8801010733 | 8088782789 | DSE017 | 2 | 8185
35 | 8801010332 | 8088007755 | DSE017 | 2 | 8185
39 | 810101199 | 8081380807 | DSE117 | 3 | 7812
37 | 8301017009 | 8083503097 | [NAME] | 3 | 5937
38 | 8301017015 | 8083503713 | [NAME] | 3 | 5937
38 | 8801010121 | 8088009308 | [NAME] | 3 | 5937
70 | 8801010811 | 8088839191 | [NAME] | 3 | 5937
71 | 8801010078 | 8088738077 | [NAME] | 3 | 5937
72 | 8801010771 | 8088383359 | [NAME] | 3 | 5937
73 | 8801010870 | 8088008190 | [NAME] | 3 | 5937
77 | 8801010327 | 8088379528 | [NAME] | 3 | 5937
75 | 8801010181 | 8088317779 | [NAME] | 3 | 5937
79 | 8801010373 | 8088351987 | [NAME] | 3 | 5937
77 | 8801010787 | 8088009732 | [NAME] | 3 | 5937
78 | 8801010855 | 8088007991 | [NAME] | 7 | 5937
78 | 8801010812 | 8088839782 | [NAME] | 3 | 5937
50 | 8801010208 | 8088370895 | [NAME] | 3credit | 5937
51 | 8801010882 | 8088587758 | [NAME] | 3 | 5937
52 | 8801010385 | 8088510391 | [NAME] | 3 | 5937
53 | 8801010919 | 8088512773 | DSE275 | 7 credits | 8031
57 | 8801010787 | 8088009732 | DSE275 | 7 | 8031
55 | 8801010811 | 8088839191 | DSE275 | 7 | 8031
59 | 8801010382 | 8088570899 | DSE275 | 7 | 8031
57 | 8801010078 | 8088738077 | DSE275 | 7 | 8031
58 | 8801010720 | 8088005093 | DSE275 | 7 | 8031
58 | 8801010381 | 8088811372 | DSE275 | 7 | 8031
90 | 8801010771 | 8088383359 | DSE275 | 7 | 8031
91 | 8801010870 | 8088008190 | DSE275 | 7 | 8031
92 | 8801010888 | 8088837222 | DSE275 | 7 | 8031
93 | 8801010181 | 8088317779 | DSE275 | 7 | 8031
97 | 8801010787 | 8088009732 | DSE275 | 2 | 8031
95 | 8801010797 | 8088787153 | DSE275 | 7 | 8031
99 | 8801010881 | 8088583798 | DSE275 | 7 | 8031
97 | 8301017009 | 8083503097 | [NAME] | 3 | 3311
98 | 8301017015 | 8083503713 | [NAME] | 3 | 3311
98 | 8801010852 | 8088903518 | [NAME] | 3 | 3311
70 | 8801010178 | 8088758095 | [NAME] | 3 credit | 3311
71 | 8801010919 | 8088512773 | [NAME] | 3 credits | 3311
72 | 8801010811 | 8088839191 | [NAME] | 3 | 3311
73 | 8801010381 | 8088811372 | [NAME] | 3 | 3311
77 | 8801010870 | 8088008190 | [NAME] | 3 | 3311
75 | 8801010181 | 8088317779 | [NAME] | 3 | 3311
79 | 8801010787 | 8088009732 | [NAME] | 3 | 3311
77 | 8801010855 | 8088007991 | [NAME] | 7 | 3311
78 | 8801010882 | 8088587758 | [NAME] | 3 | 3311
78 | 8801010297 | 8088527313 | [NAME] | 3 CREDIT | 3311
80 | 8801010797 | 8088787153 | [NAME] | 3 | 3311
81 | 8801010852 | 8088903518 | DSE278 | 3 | 8793
82 | 8801010855 | 8088007991 | DSE278 | 3 | 8793
83 | 8801010571 | 8088502123 | DSE278 | 3 | 8793
87 | 8801010838 | 8088007297 | DSE278 | 3 | 8793
85 | 8801010078 | 8088738077 | DSE278 | 3 | 8793
89 | 8801010720 | 8088005093 | DSE278 | 3 | 8793
87 | 8801010985 | 8088785153 | DSE278 | 3 | 8793
88 | 8801010733 | 8088782789 | DSE278 | 3 | 8793
88 | 8801010771 | 8088383359 | DSE278 | 3 | 8793
80 | 8801010755 | 8088380387 | DSE278 | 3 | 8793
81 | 8801010883 | 8088570125 | DSE278 | 3 | 8793
82 | 8801010270 | 8088788190 | DSE278 | 3 | 8793
83 | 8801010752 | 8088817977 | DSE278 | 3 | 8793
87 | 8801010218 | 8088590779 | DSE278 | 3 | 8793
85 | 8801010373 | 8088351987 | DSE278 | 3 | 8793
89 | 8801010577 | 8088009280 | DSE278 | 3 | 8793
87 | 8801010778 | 8088532875 | DSE278 | 3 | 8793
88 | 8801010205 | 8088773795 | DSE278 | 3 | 8793
88 | 8801010208 | 8088370895 | DSE278 | 3 credit | 8793
100 | 810121021 | 8081000008 | DSE278 | 3 credit | 8793
101 | 8801010297 | 8088527313 | DSE278 | 3 credit | 8793
102 | 8801010385 | 8088510391 | DSE278 | 3 | 8793
103 | 8801010755 | 8088380387 | DSE278 | 3 | 8793
107 | 810101779 | 8081772701 | DSE278 | 3 | 8793
105 | 8801010778 | 8088532875 | DSE278 | 3 | 8793
109 | 8801010881 | 8088583798 | DSE278 | 3 | 8793
107 | 8801010503 | 8088000235 | DSE250 | 3 | 8793
108 | 8801010178 | 8088758095 | DSE250 | 7 credit | 8175
108 | 8801010838 | 8088007297 | DSE250 | 7 | 8175
110 | 8801010752 | 8088817977 | DSE250 | 7 | 8175
111 | 8801010205 | 8088773795 | DSE250 | 7 | 8175
112 | 8801010385 | 8088510391 | DSE250 | 7 | 8175
113 | 810101779 | 8081772701 | DSE250 | 7 | 8175
117 | 8801010718 | 8088005558 | DSE251 | 7 | 8813
115 | 8801010381 | 8088811372 | DSE251 | 7 | 8813
119 | 8801010771 | 8088383359 | DSE251 | 7 | 8813
117 | 8801010503 | 8088000235 | DSE251 | 7 | 8813
118 | 8801010881 | 8088583798 | DSE251 | 7 | 8813
118 | 8801010838 | 8088007297 | DSE252 | 3 | 8005
120 | 8801010078 | 8088738077 | DSE252 | 3 | 8005
121 | 8801010115 | 8088005228 | DSE252 | 3 | 8005
122 | 8801010511 | 8088313171 | DSE252 | 3 | 8005
123 | 8801010270 | 8088788190 | DSE252 | 2 | 8005
127 | 8801010773 | 8088787297 | DSE252 | 3 | 8005
125 | 8801010787 | 8088009732 | DSE252 | 3 | 8005
129 | 810121021 | 8081000008 | DSE252 | 3 Credit | 8005
127 | 810101779 | 8081772701 | DSE252 | 3 | 8005
128 | 8301017009 | 8083503097 | DSE253 | 2 | 511
128 | 8301017015 | 8083503713 | DSE253 | 2 | 511
130 | 8801010027 | 8088007391 | DSE253 | 2 | 511
131 | 8801010852 | 8088903518 | DSE253 | 2 | 511
132 | 8801010507 | 8088789392 | DSE253 | 2 | 511
133 | 8801010381 | 8088811372 | DSE253 | 2 | 511
137 | 8801010597 | 8088309733 | DSE253 | 2 | 511
135 | 8801010710 | 8088703297 | DSE253 | 2 | 511
139 | 8801010981 | 8088009805 | DSE253 | 2 | 511
137 | 8301017009 | 8083503097 | DSE257 | 2 | 7701
138 | 8301017015 | 8083503713 | DSE257 | 2 | 7701
138 | 8101137007 | 8081398195 | DSE257 | 2 Credits | 7701
170 | 8801010811 | 8088839191 | DSE257 | 2 | 7701
171 | 8801010078 | 8088738077 | DSE257 | 2 | 7701
172 | 8801010895 | 8088008037 | DSE257 | 2 | 7701
173 | 8801010373 | 8088351987 | DSE257 | 2 | 7701
177 | 8801010981 | 8088009805 | DSE257 | 2 | 7701
175 | 8801010577 | 8088009280 | DSE257 | 2 | 7701
179 | 8801010812 | 8088839782 | DSE257 | 2 | 7701
177 | 8801010208 | 8088370895 | DSE257 | 2 credit | 7701
178 | 810121021 | 8081000008 | DSE257 | 2 credit | 7701
178 | 8801010895 | 8088008037 | CSI012 | 2 | 7508
150 | 8801010893 | 8088007731 | CSI012 | 2 | 7508
151 | 8801010713 | 8088832103 | DSP017 | 1 credit | 8597
152 | 810101172 | 8081388192 | DSP017 | 1 | 8597
153 | 8801010179 | 8088718571 | DSP017 | 1 | 8597
157 | 8801010732 | 8088713398 | DSP017 | 1 | 8597
155 | 810101150 | 8081371738 | DSP017 | 1 | 8597
159 | 8801010208 | 8088370895 | DSP017 | 1credit | 8597
157 | 810121021 | 8081000008 | DSP017 | 1 credit | 8597
158 | 8801010503 | 8088000235 | DSP017 | 1 | 8597
158 | 810101383 | 8081300973 | DSP017 | 1 | 8597
190 | 8801010818 | 8088805827 | DSP113 |  | 7812
191 | 8801010787 | 8088009732 | DSP113 | 1 | 7812
192 | 8801010385 | 8088510391 | DSP119 | 2 | 8919
193 | 8301017009 | 8083503097 | DSP272 | 1 | 8888
197 | 8301017015 | 8083503713 | DSP272 | 1 | 8888
195 | 8801010027 | 8088007391 | DSP272 | 1 | 8888
199 | 8801010852 | 8088903518 | DSP272 | 1 | 8888
197 | 8801010238 | 8088307891 | DSP272 | 1 | 8888
198 | 8801010710 | 8088703297 | DSP272 | 1 | 8888
198 | 8801010895 | 8088008037 | DSP272 | 1 | 8888
170 | 8801010855 | 8088007991 | DSP272 | 1 | 8888
171 | 8801010107 | 8088588100 | DSP272 | 1 | 8888
172 | 8801010881 | 8088555807 | DSP272 | 1 | 8888
173 | 8801010385 | 8088510391 | DSP272 | 1 | 8888
177 | 8301017009 | 8083503097 | DSP273 | 1 | 8919
175 | 8301017015 | 8083503713 | DSP273 | 1 | 8919
179 | 8801010027 | 8088007391 | DSP273 | 1 | 8919
177 | 8801010381 | 8088811372 | DSP273 | 1 | 8919
178 | 8801010771 | 8088757752 | DSP273 | 1 | 8919
178 | 8801010558 | 8088777888 | DSP273 | 1 | 8919
180 | 8301017009 | 8083503097 | DSP277 | 1 | 8979
181 | 8301017015 | 8083503713 | DSP277 | 1 | 8979
182 | 8801010713 | 8088832103 | DSP277 | 1 credit | 8979
183 | 8801010811 | 8088839191 | DSP277 | 1 | 8979
187 | 8801010930 | 8088007982 | DSP277 | 1 | 8979
185 | 8801010720 | 8088005093 | DSP277 | 1 | 8979
189 | 8801010381 | 8088811372 | DSP277 | 1 | 8979
187 | 8801010918 | 8088000788 | DSP277 | 1 | 8979
188 | 8801010898 | 8088008129 | DSP277 | 1 | 8979
188 | 8801010218 | 8088590779 | DSP277 | 1 | 8979
180 | 8801010855 | 8088007991 | DSP277 | 1 | 8979
181 | 8801010812 | 8088839782 | DSP277 | 1 | 8979
182 | 8801010977 | 8088357810 | DSP277 | 1 | 8979
183 | 8801010713 | 8088832103 | DSP278 | 1 credit | 9775
187 | 8801010571 | 8088502123 | DSP278 | 1 credit | 9775
185 | 8801010720 | 8088005093 | DSP278 | 1 | 9775
189 | 8801010985 | 8088785153 | DSP278 | 1 | 9775
187 | 8801010825 | 8088733389 | DSP278 | 1 | 9775
188 | 8801010511 | 8088313171 | DSP278 | 1 | 9775
188 | 8801070028 | 8088003771 | DSP278 | 1 | 9775
200 | 8801010707 | 8088009109 | DSP278 | 1 | 9775
201 | 8801010855 | 8088007991 | DSP278 | 1 | 9775
202 | 8801010208 | 8088370895 | DSP278 | 1credit | 9775
203 | 810121021 | 8081000008 | DSP278 | 1 credit | 9775
207 | 8801010503 | 8088000235 | DSP278 | 1 | 9775
205 | 8801010933 | 8088009712 | DSP278 | 1 | 9775
209 | 8801010087 | 8088005817 | [NAME] | 1 | 7717
207 | 8801010855 | 8088918109 | [NAME] | 1 | 7717
208 | 8801010258 | 8088385885 | [NAME] | 1 | 7717
208 | 8801010707 | 8088009109 | [NAME] | 1 | 7717
210 | 8801010178 | 8088758095 | [NAME] | 1 credit | 7717
211 | 8801010189 | 8088508572 | [NAME] | 1 | 7717
212 | 8801010178 | 8088758095 | DSP252 | 1 credit | 8828
213 | 8801010713 | 8088832103 | DSP252 | 1 credit | 8828
217 | 8801010720 | 8088005093 | DSP252 | 1 | 8828
215 | 8801010985 | 8088785153 | DSP252 | 1 | 8828
219 | 8801010825 | 8088733389 | DSP252 | 1 | 8828
217 | 8801010115 | 8088005228 | DSP252 | 1 | 8828
218 | 8801010258 | 8088385885 | DSP252 | 1 | 8828
218 | 8801010707 | 8088009109 | DSP252 | 1 | 8828
220 | 8801010037 | 8088525892 | DSP252 | 1 | 8828
221 | 8801010027 | 8088007391 | DSP257 | 2 | 7893
222 | 8801010852 | 8088903518 | DSP257 | 2 | 7893
223 | 8801010811 | 8088839191 | DSP257 | 2 | 7893
227 | 8801010720 | 8088005093 | DSP257 | 2 | 7893
225 | 8801010980 | 8088509907 | DSP257 | 2 | 7893
229 | 8801010927 | 8088508175 | DSP257 | 2 | 7893
227 | 8801010270 | 8088788190 | DSP257 | 2 | 7893
228 | 8801010019 | 8088009231 | DSP257 | 2 | 7893
228 | 8801010037 | 8088525892 | DSP257 | 2 | 7893
230 | 8801010855 | 8088007991 | DSP257 | 2 | 7893
231 | 8801010830 | 8088509228 | DSP257 | 2 | 7893
232 | 8801010337 | 8088777958 | DSP257 | 2 | 7893
233 | 8801010503 | 8088000235 | DSP257 | 2 | 7893
237 | 8801010557 | 8088797782 | DSP257 | 2 | 7893
235 | 8801010713 | 8088832103 | DSP287 | 2 credits | 8708
239 | 8801010180 | 8088003287 | DSP287 | 2 | 8708
237 | 8801010985 | 8088785153 | DSP287 | 2 | 8708
238 | 8801010732 | 8088713398 | DSP287 | 1 | 8708
238 | 8801010238 | 8088307891 | DSP287 | 2 | 8708
270 | 8801010087 | 8088005817 | DSP287 | 2 | 8708
271 | 8801010883 | 8088570125 | DSP287 | 2 | 8708
272 | 8801010232 | 8088707180 | DSP287 | 2 | 8708
273 | 8801010270 | 8088788190 | DSP287 | 2 | 8708
277 | 8801010258 | 8088385885 | DSP287 | 2 | 8708
275 | 8801010855 | 8088007991 | DSP287 | 2 | 8708
279 | 8801010208 | 8088370895 | DSP287 | 2credit | 8708
277 | 8801010503 | 8088000235 | DSP287 | 2 | 8708
278 | 8801010290 | 8088552129 | EEE MOO207 | 2 | 8793
278 | 8801010385 | 8088510391 | EEP112 | 1 | 557
250 | 8801010977 | 8088357810 | EEP112 | 1 | 557
251 | 8801010981 | 8088009805 | JED000 | 2 | 5999
252 | 8801010895 | 8088008037 | JED001 | 2 | 5999
253 | 8801010911 | 8088727339 | JED001 | 2 | 5999
257 | 8801010985 | 8088785153 | JED001 | 2 | 5999
255 | 8801010732 | 8088713398 | JED001 | 2 | 5999
259 | 8801010178 | 8088325232 | JED001 | 2 | 5999
257 | 8801010719 | 8088503088 | JED001 | 2 | 5999
258 | 8801010238 | 8088307891 | JED001 | 2 | 5999
258 | 8801010853 | 8088903888 | JED001 | 2 | 5999
290 | 8801010927 | 8088508175 | JED001 | 2 | 5999
291 | 8801010218 | 8088590779 | JED001 | 2 | 5999
292 | 8801010830 | 8088509228 | JED001 | 2 | 5999
293 | 8801010571 | 8088502123 | JED001 | 2 | 5999
297 | 8801010087 | 8088005817 | MEP105 | 1.5
295 | 8801010893 | 8088007731 | MTH172 | 7 | 8780
299 | 8801010981 | 8088009805 | MTH172 | 7 | 8780
297 | 810101172 | 8081388192 | MTH175 | 7 | 8780
298 | 810101058 | 8081301833 | MTH175 | 7 | 8780
298 | 8801010893 | 8088007731 | ONB703 | 2 | 8338
270 | 8801010991 | 8088009788 | ONB703 | 2 | 8338
271 | 8801010087 | 8088005817 | PHYI92 | 1 | 8989