Spreadsheet: 798981d1664849574-help-using-an-if-function-in-a-formula-that-uses-iferror-and-index-sample-1
Sheet: Sheet1

Comp | BA1 | 2022-08-17 12:51:00 | 2022-08-17 13:07:00 | OE-653854 | Ent | pen | 101 | Other | Lse/Ma | s00638175 |  | 5296 | IL | 2022-08-19 00:00:00 | 1 |  | 321 | 388 | South | 54 | No
Pre | BA2 | 2022-08-17 13:12:00 | 2022-08-17 13:22:00 | OE-653857 | Ent | pen | 102 | National | Sld/Ma |  | 80048156 | 67813 | DC | 2022-08-17 00:00:00 | 1 |  | 456 | 654 | Eastern | 5 | No
Comp | BA3 | 2022-08-17 14:03:00 | 2022-08-17 14:30:00 | OE-653870 | Ent | pen | 103 | Other | Lse/Ma | s00635386 |  | 16165 | OK | 2022-08-19 00:00:00 | 3 |  | 789 | 388 | South | 54 | No
Pre | BA4 | 2022-08-17 14:42:00 | 2022-08-17 14:46:00 | OE-653888 | Ent | pen | 104 | Other | Lse/Ma | S00638627 |  | 3314 | FL | 2022-08-19 00:00:00 | 1 | 1 | 3241 | 681 | South | 53 | No
Comp | BA5 | 2022-08-18 11:05:00 | 2022-08-18 11:25:00 | OE-653996 | Ent | pen | 105 | Key | Sld/Ma | s00638818 |  | 5670 | OH | 2022-09-30 00:00:00 | 1 | 0 | 654 | 925 | Central | 28 | No
Pre | BA6 | 2022-08-18 13:46:00 | 2022-08-18 13:48:00 | OE-654037 | Ent | pen | 106 | National | Sld/Ma |  | 80048690 | 3368 | MO | 2022-08-22 00:00:00 | 1 |  | 987 | 124 | Eastern | 6 | No
Comp | BA7 | 2022-08-18 17:04:00 | 2022-08-19 09:58:00 | OE-654105 | Ent | pen | 107 | Other | Lse/Ma | S00638787 |  | 12027 | MA | 2022-08-31 00:00:00 | 1 | 1 | 54 | 388 | South | 54 | No
Pre | BA8 | 2022-08-19 13:08:00 | 2022-08-19 13:24:00 | OE-654194 | Ent | pen | 108 | Other | Sld/Ma | S00637062 |  | 2595 | OH | 2022-08-22 00:00:00 | 1 | 0 | 82 | 241 | Central | 28 | No
Comp | BA9 | 2022-08-19 18:14:00 | 2022-08-19 19:14:00 | OE-654252 | Ent | pen | 109 | Other | Lse/Ma | S00636579 |  | 27210 | CA | 2022-09-14 00:00:00 | 4 | 0 | 29 | 464 | Western | 78 | No
Pre | BA10 | 2022-08-19 17:26:00 | 2022-08-19 20:17:00 | OE-654245 | Ent | pen | 110 | Key | Lse/Ma | S00639028 |  | 6818 | NJ | 2022-08-25 00:00:00 | 1 | 0 | 24 | 462 | Western | 76 | No
 | BA11 | 2022-09-01 13:34:00 | 2022-09-08 13:05:00 | OE-655810 | Ent | pen | 111 | Key | Lse/Ma | S00639043 |  | 1886 | NJ | 2022-09-16 00:00:00 | 1 | 1 | 77 | 654 | Eastern | 5 | No
 | BA12 | 2022-09-08 15:07:00 | 2022-09-08 15:56:00 | OE-656374 | Ent | pen | 112 | Other | Sld/Ma |  |  | 3438 | FL | 2022-10-31 00:00:00 | 1 | 0 | 89 | 908 | Eastern | 5 | No
 | [NAME] | 2022-09-08 16:30:00 | 2022-09-08 16:48:00 | OE-656395 | Ent | pen | 113 | National | Sld/Ma | S00640426 |  | 1806 | IA | 2022-09-12 00:00:00 | 3 |  | 98 | 124 | Eastern | 6 | No
 | BA14 | 2022-09-09 09:31:00 | 2022-09-09 09:37:00 | OE-656435 | Ent | pen | 114 | Key | Sld/Ma | S00640454 |  | 1236 | OH | 2022-10-14 00:00:00 | 1 | 0 | 20 | 241 | Central | 28 | No
 | BA15 | 2022-08-30 09:57:00 | 2022-09-09 12:18:00 | OE-655363 | Ent | pen | 115 | Key | RmaOnly |  |  |  | VA | 2022-09-12 00:00:00 | 0 | 1 | 30 | 959 | Eastern | 5 | No
 | BA16 | 2022-09-09 18:25:00 | 2022-09-12 08:24:00 | OE-656543 | Ent | pen | 116 | Other | Lse/Ma | s00640088 |  | 8500 | FL | 2022-09-23 00:00:00 | 1 | 0 | 50 | 929 | Central | 31 | No
 | BA17 | 2022-09-09 16:13:00 | 2022-09-12 10:08:00 | OE-656520 | Ent | pen | 117 | National | Sld/Ma | s00640448 |  | 3918 | DE | 2022-09-20 00:00:00 | 3 | 3 | 40 | 128 | Eastern | 4 | No
 | BA18 | 2022-09-12 11:29:00 | 2022-09-12 11:57:00 | OE-656608 | Ent | pen | 118 | Other | RmaOnly |  |  |  | AL | 2022-09-14 00:00:00 | 2 | 0 | 55 | 388 | South | 54 | No
 | BA19 | 2022-09-12 12:32:00 | 2022-09-12 13:32:00 | OE-656627 | Ent | pen | 119 | Key | RmaOnly |  |  |  | KY | 2022-09-30 00:00:00 | 0 | 5 | 77 | 910 | Central | 28 | No
 | BA20 | 2022-09-13 11:18:00 | 2022-09-13 12:13:00 | OE-656750 | Ent | pen | 120 | Other | RmaOnly |  |  |  | NY | 2022-09-16 00:00:00 | 0 | 1 | 89 | 654 | Eastern | 5 | No
 | BA21 | 2022-09-13 14:04:00 | 2022-09-13 16:08:00 | OE-656789 | Ent | pen | 121 | P4P | Lse/Ma |  | 80049981 | 18585 | NV | 2022-09-30 00:00:00 | 2 | 2 | 98 | 464 | Western | 78 | No