Spreadsheet: 150040d1334256526-vlookup-and-if-statement-combos-help-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 100 | 500 | 1000 | 2 | 100 | 500 | 1000 | 2 | 100 | 500 | 1000 | 2 | 100 | 500 | 1000 | 2 | 100 | 500 | 1000 | 2 | 100 | 500 | 1000 | 2 | 100 | 500 | 1000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xxxx | xxxx | xxxx | xxxx | xxx | xxx | xxx | xxx | xxx+xxxxxx | xxx+xxxxxx | xxx+xxxxxx | xxx+xxxxxx | xxxx+xxx+xxxxxx | xxxx+xxx+xxxxxx | xxxx+xxx+xxxxxx | xxxx+xxx+xxxxxx | xxxxxx | xxxxxx | xxxxxx | xxxxxx | xxxx+xxx | xxxx+xxx | xxxx+xxx | xxxx+xxx | xxxx+xxxxxx | xxxx+xxxxxx | xxxx+xxxxxx | xxxx+xxxxxx
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2-99 | 100-499 | 500-999 | 1000-999999 | 2-99 | 100-499 | 500-999 | 1000-999999 | 2-99 | 100-499 | 500-999 | 1000-999999 | 2-99 | 100-499 | 500-999 | 1000-999999 | 2-99 | 100-499 | 500-999 | 1000-999999 | 2-99 | 100-499 | 500-999 | 1000-999999 | 2-99 | 100-499 | 500-999 | 1000-999999
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 30 | 77 | 1 | 76 | 10 | 99 | 67 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | n/a | 0.7 | n/a | n/a
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 81 | 70 | 4 | 41 | 57 | 0.42 | 0.42 | 79 |  |  |  |  |  |  |  |  |  |  |  |  | n/a | 0.8 | n/a | n/a
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 86 | 79 | 37 | 96 | 28 | 4 | 29 | 38 |  |  |  |  |  |  |  |  |  |  |  |  | n/a | n/a | 0.1 | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 87 | 5 | 94 | 36 | 30 | 94 | 97 | 40 |  |  |  |  |  |  |  |  |  |  |  |  | n/a | n/a | 0.2 | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 52 | 76 | 5 | 59 | 27 | 16 | 16 | 64 |  |  |  |  |  |  |  |  |  |  |  |  | n/a | n/a | 0.3 | 0.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 46 | 29 | 62 | 64 | 41 | 41 | 71 | 32 |  |  |  |  |  |  |  |  |  |  |  |  | n/a | n/a | 0.4 | 0.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 26 | 27 | 82 | 82 | 63 | 20 | 18 | 58 |  |  |  |  |  |  |  |  |  |  |  |  | n/a | n/a | 0.5 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 58 | 98 | 91 | 22 | 8 | 45 | 90 | 26 |  |  |  |  |  |  |  |  |  |  |  |  | n/a | n/a | 0.6 | 0.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xxxx | AA12
 |  |  |  | xxxx | 1 |  | NEW FORMULA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xxx | AE12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xxx+xxxxxx | AI12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xxxx+xxx+xxxxxx | AM12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xxxxxx | AQ12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xxxx+xxx | AU12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xxxx+xxxxxx | AY12
 |  |  |  |  | 98
 |  |  |  | xxxx | xxx
 |  |  |  | 0.75 | 0.25