Spreadsheet: 22836d1211994465-vlookup-help-posted-online
Sheet: Accounts

CUST_ID |  | Discount Structure | FY07
557 | METER-MIXRESELLER | =(IF(D2<3900,VLOOKUP(B2,Definitions!$A$2:$C$16,3,)))*OR(IF(D2>=3900,VLOOKUP(B2,Definitions!$A$20:$A$33,3,))) | 65.17
259 | ADH PKGRESELLER | E44 | 95.4
258 | ADH PKGRESELLER | E44 | 100.1
141 | ADH PKGOEM | E48 | 100.7
471 | METER-MIXOEM | E47 | 100.8
32 | ADH PKGEND USER | E44 | 101
140 | ADH PKGOEM | E48 | 101.1
356 | METER-MIXEND USER | E44 | 101.14
139 | ADH PKGOEM | E48 | 101.5
1 | ADH PKG MDEND USER | E44 | 101.72
138 | ADH PKGOEM | E48 | 102
304 | CPIOEM | 0 | 104.38
355 | METER-MIXEND USER | E44 | 105
556 | METER-MIXRESELLER | E44 | 105.52
555 | METER-MIXRESELLER | E44 | 105.93
554 | METER-MIXRESELLER | E44 | 106
553 | METER-MIXRESELLER | E44 | 106.03
354 | METER-MIXEND USER | E44 | 108.36
257 | ADH PKGRESELLER | E44 | 109.18
256 | ADH PKGRESELLER | E44 | 110
137 | ADH PKGOEM | E48 | 113.6
255 | ADH PKGRESELLER | E44 | 116.6
353 | METER-MIXEND USER | E44 | 117
352 | METER-MIXEND USER | E44 | 118.62
254 | ADH PKGRESELLER | E44 | 118.72
303 | CPIOEM | 0 | 118.96
470 | METER-MIXOEM | E47 | 119.31
31 | ADH PKGEND USER | E44 | 120.6
30 | ADH PKGEND USER | E44 | 126
253 | ADH PKGRESELLER | E44 | 127.2
351 | METER-MIXEND USER | E44 | 130.84
350 | METER-MIXEND USER | E44 | 133
252 | ADH PKGRESELLER | E44 | 136
251 | ADH PKGRESELLER | E44 | 136.21
302 | CPIOEM | 0 | 138.1
469 | METER-MIXOEM | E47 | 140
349 | METER-MIXEND USER | E44 | 141
552 | METER-MIXRESELLER | E44 | 141
348 | METER-MIXEND USER | E44 | 145.33
468 | METER-MIXOEM | E47 | 145.59
136 | ADH PKGOEM | E48 | 158.26
301 | CPIOEM | 0 | 160
347 | METER-MIXEND USER | E44 | 160
467 | METER-MIXOEM | E47 | 165.97
551 | METER-MIXRESELLER | E44 | 168.14
346 | METER-MIXEND USER | E44 | 171.1
135 | ADH PKGOEM | E48 | 174.9
466 | METER-MIXOEM | E47 | 176.2
134 | ADH PKGOEM | E48 | 177.5
133 | ADH PKGOEM | E48 | 186.97
344 | METER-MIXEND USER | E44 | 188
345 | METER-MIXEND USER | E44 | 188
343 | METER-MIXEND USER | E44 | 188.28
550 | METER-MIXRESELLER | E44 | 190
465 | METER-MIXOEM | E47 | 193.48
342 | METER-MIXEND USER | E44 | 200
464 | METER-MIXOEM | E47 | 200
549 | METER-MIXRESELLER | E44 | 200
463 | METER-MIXOEM | E47 | 207.52
250 | ADH PKGRESELLER | E44 | 212
341 | METER-MIXEND USER | E44 | 212
132 | ADH PKGOEM | E48 | 212.5
249 | ADH PKGRESELLER | E44 | 218
131 | ADH PKGOEM | E48 | 219.31
340 | METER-MIXEND USER | E44 | 237.5
462 | METER-MIXOEM | E47 | 237.62
248 | ADH PKGRESELLER | E44 | 239.02
461 | METER-MIXOEM | E47 | 240
300 | CPIOEM | 0 | 243.62
460 | METER-MIXOEM | E47 | 247.34
130 | ADH PKGOEM | E48 | 254.4
548 | METER-MIXRESELLER | E44 | 259.31
459 | METER-MIXOEM | E47 | 268.14
339 | METER-MIXEND USER | E44 | 270
458 | METER-MIXOEM | E47 | 273.1
247 | ADH PKGRESELLER | E44 | 280
457 | METER-MIXOEM | E47 | 280
129 | ADH PKGOEM | E48 | 290
547 | METER-MIXRESELLER | E44 | 292.41
128 | ADH PKGOEM | E48 | 305.28
127 | ADH PKGOEM | E48 | 307.4
126 | ADH PKGOEM | E48 | 320.69
125 | ADH PKGOEM | E48 | 325
29 | ADH PKGEND USER | E44 | 331.03
338 | METER-MIXEND USER | E44 | 340
546 | METER-MIXRESELLER | E44 | 342
337 | METER-MIXEND USER | E44 | 342.07
336 | METER-MIXEND USER | E44 | 344.7
456 | METER-MIXOEM | E47 | 344.83
545 | METER-MIXRESELLER | E44 | 351.51
544 | METER-MIXRESELLER | E44 | 354.33
124 | ADH PKGOEM | E48 | 371
299 | CPIOEM | 0 | 374.2
335 | METER-MIXEND USER | E44 | 378
334 | METER-MIXEND USER | E44 | 380
246 | ADH PKGRESELLER | E44 | 385.3
28 | ADH PKGEND USER | E44 | 388.5
245 | ADH PKGRESELLER | E44 | 391
27 | ADH PKGEND USER | E44 | 396.5
333 | METER-MIXEND USER | E44 | 400
543 | METER-MIXRESELLER | E44 | 400.13
26 | ADH PKGEND USER | E44 | 400.8
123 | ADH PKGOEM | E48 | 402.82
542 | METER-MIXRESELLER | E44 | 407.45
122 | ADH PKGOEM | E48 | 414.08
541 | METER-MIXRESELLER | E44 | 426.25
332 | METER-MIXEND USER | E44 | 428.02
455 | METER-MIXOEM | E47 | 430.15
121 | ADH PKGOEM | E48 | 431.9
120 | ADH PKGOEM | E48 | 432
454 | METER-MIXOEM | E47 | 435.13
244 | ADH PKGRESELLER | E44 | 448.7
540 | METER-MIXRESELLER | E44 | 461.5
453 | METER-MIXOEM | E47 | 466
452 | METER-MIXOEM | E47 | 475
331 | METER-MIXEND USER | E44 | 477.16
451 | METER-MIXOEM | E47 | 487.86
539 | METER-MIXRESELLER | E44 | 488.2
450 | METER-MIXOEM | E47 | 491.98
330 | METER-MIXEND USER | E44 | 493.83
119 | ADH PKGOEM | E48 | 558.62
449 | METER-MIXOEM | E47 | 560
538 | METER-MIXRESELLER | E44 | 563.34
243 | ADH PKGRESELLER | E44 | 582.18
118 | ADH PKGOEM | E48 | 583
537 | METER-MIXRESELLER | E44 | 617.93
25 | ADH PKGEND USER | E44 | 625.35
448 | METER-MIXOEM | E47 | 639.78
24 | ADH PKGEND USER | E44 | 640
117 | ADH PKGOEM | E48 | 643.17
447 | METER-MIXOEM | E47 | 644.44
242 | ADH PKGRESELLER | E44 | 669.84
329 | METER-MIXEND USER | E44 | 680
446 | METER-MIXOEM | E47 | 682.14
298 | CPIOEM | 0 | 692.52
241 | ADH PKGRESELLER | E44 | 700
328 | METER-MIXEND USER | E44 | 703.45
445 | METER-MIXOEM | E47 | 704
240 | ADH PKGRESELLER | E44 | 704.89
327 | METER-MIXEND USER | E44 | 708.64
116 | ADH PKGOEM | E48 | 710.84
115 | ADH PKGOEM | E48 | 717.4
23 | ADH PKGEND USER | E44 | 734.69
114 | ADH PKGOEM | E48 | 735.14
536 | METER-MIXRESELLER | E44 | 736.57
535 | METER-MIXRESELLER | E44 | 737.5
326 | METER-MIXEND USER | E44 | 738.55
444 | METER-MIXOEM | E47 | 740.8
239 | ADH PKGRESELLER | E44 | 746.55
443 | METER-MIXOEM | E47 | 754.76
113 | ADH PKGOEM | E48 | 770
534 | METER-MIXRESELLER | E44 | 776.3
238 | ADH PKGRESELLER | E44 | 778.43
112 | ADH PKGOEM | E48 | 784.99
442 | METER-MIXOEM | E47 | 796.55
325 | METER-MIXEND USER | E44 | 814.36
324 | METER-MIXEND USER | E44 | 816.25
111 | ADH PKGOEM | E48 | 859.16
533 | METER-MIXRESELLER | E44 | 886.94
441 | METER-MIXOEM | E47 | 889.81
237 | ADH PKGRESELLER | E44 | 896.61
440 | METER-MIXOEM | E47 | 900
110 | ADH PKGOEM | E48 | 901.97
323 | METER-MIXEND USER | E44 | 920
236 | ADH PKGRESELLER | E44 | 921.5
439 | METER-MIXOEM | E47 | 932.48
322 | METER-MIXEND USER | E44 | 951.72
438 | METER-MIXOEM | E47 | 954.5
532 | METER-MIXRESELLER | E44 | 965.52
321 | METER-MIXEND USER | E44 | 986.99
531 | METER-MIXRESELLER | E44 | 1019.19
530 | METER-MIXRESELLER | E44 | 1031.37
437 | METER-MIXOEM | E47 | 1063.92
436 | METER-MIXOEM | E47 | 1080
320 | METER-MIXEND USER | E44 | 1098
235 | ADH PKGRESELLER | E44 | 1110.34
529 | METER-MIXRESELLER | E44 | 1116.14
319 | METER-MIXEND USER | E44 | 1140
435 | METER-MIXOEM | E47 | 1145.36
434 | METER-MIXOEM | E47 | 1149.59
528 | METER-MIXRESELLER | E44 | 1165
6 | ADH PKG MDOEM | E48 | 1187.2
234 | ADH PKGRESELLER | E44 | 1207.2
109 | ADH PKGOEM | E48 | 1266.19
318 | METER-MIXEND USER | E44 | 1270
317 | METER-MIXEND USER | E44 | 1280
108 | ADH PKGOEM | E48 | 1310.9
16 | ADH PKG MDRESELLER | E44 | 1353.1
433 | METER-MIXOEM | E47 | 1380.46
432 | METER-MIXOEM | E47 | 1433.1
233 | ADH PKGRESELLER | E44 | 1440
107 | ADH PKGOEM | E48 | 1466.48
527 | METER-MIXRESELLER | E44 | 1475.86
431 | METER-MIXOEM | E47 | 1507.24
106 | ADH PKGOEM | E48 | 1526
430 | METER-MIXOEM | E47 | 1530.7
429 | METER-MIXOEM | E47 | 1545.59
105 | ADH PKGOEM | E48 | 1579.16
428 | METER-MIXOEM | E47 | 1615.1
232 | ADH PKGRESELLER | E44 | 1619
231 | ADH PKGRESELLER | E44 | 1653.4
104 | ADH PKGOEM | E48 | 1668
22 | ADH PKGEND USER | E44 | 1696.55
526 | METER-MIXRESELLER | E44 | 1704.45
103 | ADH PKGOEM | E48 | 1716.6
230 | ADH PKGRESELLER | E44 | 1741.03
102 | ADH PKGOEM | E48 | 1840.5
101 | ADH PKGOEM | E48 | 1924
229 | ADH PKGRESELLER | E44 | 1931.03
427 | METER-MIXOEM | E47 | 1955.7
525 | METER-MIXRESELLER | E44 | 1969.16
100 | ADH PKGOEM | E48 | 1980
524 | METER-MIXRESELLER | E44 | 2023.45
426 | METER-MIXOEM | E47 | 2052.41
99 | ADH PKGOEM | E48 | 2080
98 | ADH PKGOEM | E48 | 2127
425 | METER-MIXOEM | E47 | 2131.4
97 | ADH PKGOEM | E48 | 2137.93
424 | METER-MIXOEM | E47 | 2156.79
423 | METER-MIXOEM | E47 | 2238.48
15 | ADH PKG MDRESELLER | E44 | 2345
523 | METER-MIXRESELLER | E44 | 2352
96 | ADH PKGOEM | E48 | 2400
228 | ADH PKGRESELLER | E44 | 2408.7
316 | METER-MIXEND USER | E44 | 2448.28
227 | ADH PKGRESELLER | E44 | 2739.31
315 | METER-MIXEND USER | E44 | 2780
314 | METER-MIXEND USER | E44 | 2786.76
95 | ADH PKGOEM | E48 | 2827.59
94 | ADH PKGOEM | E48 | 2854.8
522 | METER-MIXRESELLER | E44 | 2855.17
313 | METER-MIXEND USER | E44 | 2906
422 | METER-MIXOEM | E47 | 2926.21
521 | METER-MIXRESELLER | E44 | 2938.87
93 | ADH PKGOEM | E48 | 2963.8
312 | METER-MIXEND USER | E44 | 2968
92 | ADH PKGOEM | E48 | 3017.24
520 | METER-MIXRESELLER | E44 | 3281.47
5 | ADH PKG MDOEM | E48 | 3310.34
226 | ADH PKGRESELLER | E44 | 3315.59
91 | ADH PKGOEM | E48 | 3333.72
421 | METER-MIXOEM | E47 | 3492.6
519 | METER-MIXRESELLER | E44 | 3570.07
420 | METER-MIXOEM | E47 | 3618.3
90 | ADH PKGOEM | E48 | 3680
518 | METER-MIXRESELLER | E44 | 3718.78
225 | ADH PKGRESELLER | E44 | 3724.34
517 | METER-MIXRESELLER | E44 | 3729.26
419 | METER-MIXOEM | E47 | 3750.9
224 | ADH PKGRESELLER | E44 | 3852.08
223 | ADH PKGRESELLER | 0 | 3903
89 | ADH PKGOEM | 0 | 4016.55
222 | ADH PKGRESELLER | 0 | 4160.88
418 | METER-MIXOEM | 0 | 4165.74
88 | ADH PKGOEM | 0 | 4228.97
311 | METER-MIXEND USER | 0 | 4257.37
417 | METER-MIXOEM | 0 | 4278.4
87 | ADH PKGOEM | 0 | 4293.82
221 | ADH PKGRESELLER | 0 | 4320
416 | METER-MIXOEM | 0 | 4325.04
415 | METER-MIXOEM | 0 | 4550.37
220 | ADH PKGRESELLER | 0 | 4554
516 | METER-MIXRESELLER | 0 | 4568.1
414 | METER-MIXOEM | 0 | 4811.98
310 | METER-MIXEND USER | 0 | 4924.14
515 | METER-MIXRESELLER | 0 | 5035
86 | ADH PKGOEM | 0 | 5081.93
413 | METER-MIXOEM | 0 | 5093.02
412 | METER-MIXOEM | 0 | 5149.59
514 | METER-MIXRESELLER | 0 | 5201.15
411 | METER-MIXOEM | 0 | 5409.44
513 | METER-MIXRESELLER | 0 | 5558.13
410 | METER-MIXOEM | 0 | 5666.87
512 | METER-MIXRESELLER | 0 | 6331.27
81 | ADH PKGOEM | 0 | 9552
402 | METER-MIXOEM | 0 | 9643.37
508 | METER-MIXRESELLER | 0 | 9693.54
80 | ADH PKGOEM | 0 | 10479.4
507 | METER-MIXRESELLER | 0 | 10891.71
215 | ADH PKGRESELLER | 0 | 11118.99
401 | METER-MIXOEM | 0 | 11230.34
79 | ADH PKGOEM | 0 | 11339.4
400 | METER-MIXOEM | 0 | 11373.93
78 | ADH PKGOEM | 0 | 11760.11
399 | METER-MIXOEM | 0 | 11887.03
506 | METER-MIXRESELLER | 0 | 12602.88
214 | ADH PKGRESELLER | 0 | 12898
213 | ADH PKGRESELLER | 0 | 13341.38
398 | METER-MIXOEM | 0 | 13566.69
397 | METER-MIXOEM | 0 | 14028.37
77 | ADH PKGOEM | 0 | 14070
212 | ADH PKGRESELLER | 0 | 14282.76
505 | METER-MIXRESELLER | 0 | 14666.7
76 | ADH PKGOEM | 0 | 15131.35
504 | METER-MIXRESELLER | 0 | 15144.28
211 | ADH PKGRESELLER | 0 | 15265
396 | METER-MIXOEM | 0 | 15862.99
395 | METER-MIXOEM | 0 | 16255.94
394 | METER-MIXOEM | 0 | 17089.67
75 | ADH PKGOEM | 0 | 17465.5
74 | ADH PKGOEM | 0 | 18548.28
393 | METER-MIXOEM | 0 | 19086.9
21 | ADH PKGEND USER | 0 | 19751.72
210 | ADH PKGRESELLER | 0 | 19811.52
503 | METER-MIXRESELLER | 0 | 22664.93
73 | ADH PKGOEM | 0 | 23263.62
72 | ADH PKGOEM | 0 | 26722.4
392 | METER-MIXOEM | 0 | 26930.91
71 | ADH PKGOEM | 0 | 28171.71
54 | ADH PKGFILLER | 0 | 29204.76
391 | METER-MIXOEM | 0 | 30810.34
390 | METER-MIXOEM | 0 | 33361.46
209 | ADH PKGRESELLER | 0 | 35249.21
389 | METER-MIXOEM | 0 | 35289.97
70 | ADH PKGOEM | 0 | 35830.34
14 | ADH PKG MDRESELLER | 0 | 37827.59
388 | METER-MIXOEM | 0 | 39307.83
69 | ADH PKGOEM | 0 | 42339.06
53 | ADH PKGFILLER | 0 | 44049.6
68 | ADH PKGOEM | 0 | 45610.49
387 | METER-MIXOEM | 0 | 48001.05
67 | ADH PKGOEM | 0 | 49303.38
66 | ADH PKGOEM | 0 | 50740
65 | ADH PKGOEM | 0 | 50896.6
64 | ADH PKGOEM | 0 | 51230.8
63 | ADH PKGOEM | 0 | 52778.15
386 | METER-MIXOEM | 0 | 52850.54
208 | ADH PKGRESELLER | 0 | 54574.87
52 | ADH PKGFILLER | 0 | 59296.39
62 | ADH PKGOEM | 0 | 63680.2
4 | ADH PKG MDOEM | 0 | 64793.48
61 | ADH PKGOEM | 0 | 68441
51 | ADH PKGFILLER | 0 | 73275.19
60 | ADH PKGOEM | 0 | 74129.31
309 | [NAME] | 0 | 81176.01
20 | ADH PKGDISTRIBUTOR | 0 | 97207.01
308 | [NAME] | 0 | 100838.49
3 | ADH PKG MDOEM | 0 | 109683.8
50 | ADH PKGFILLER | 0 | 112164
49 | ADH PKGFILLER | 0 | 113936.14
48 | ADH PKGFILLER | 0 | 116839.61
47 | ADH PKGFILLER | 0 | 128734.62
2 | ADH PKG MDOEM | 0 | 143934.78
59 | ADH PKGOEM | 0 | 175564.9
58 | ADH PKGOEM | 0 | 265927.6
57 | ADH PKGOEM | 0 | 294318.94