Spreadsheet: 848972d1699553248-multiple-vlookup-formulas-resulting-in-n-a-manual-airtime-testing-forum
Sheet: Monthly Call Details

CustomerCode | Service Type | Mobile Number | Date | Time | Call Type | Destination # | Destination Country | Usage | Usage Type | Rate | Total
 | Iridium | 881623458935 | 2023-10-07 00:00:00 | 04:26:35 | Iridium Voice Terrestrial | 19074515140 | USA | 3 | Minute |  |  |  | [NAME] | Background IP | 3
 | Iridium | 881623458935 | 2023-10-07 00:00:00 | 22:24:07 | Iridium Voice Terrestrial | 19074515140 | USA | 0.3333333333333333 | Minute |  |  |  | [NAME] | [NAME] | 4
 | Iridium | 881622479985 | 2023-10-26 00:00:00 | 13:43:46 | Iridium Call Forward Iridium | 881662990000 |  | 0.3333333333333333 | Minute |  |  |  | [NAME] | [NAME] IP Mobile to Fixed to Terrestrial | 5
 | Iridium | 881623432463 | 2023-10-22 00:00:00 | 07:36:04 | Iridium Call Forward Iridium | 881662990000 |  | 0.3333333333333333 | Minute |  |  |  | [NAME] | BGAN Interactive IP BGAN Default | 6
 | Iridium | 881651434864 | 2023-10-19 00:00:00 | 20:04:44 | Iridium Voice Cellular | 573138859722 | COL | 0.6666666666666666 | Minute |  |  |  | [NAME] | BGAN SMS Mobile to fixed to Terrestrial Cellular | 7
 | Iridium | 881651488682 | 2023-10-24 00:00:00 | 09:21:33 | Iridium Voice Terrestrial | 26622313260 | LSO | 1.333333333333333 | Minute |  |  |  | [NAME] | BGAN SMS Mobile to mobile to INMM | 8
 | Iridium | 881622479247 | 2023-10-25 00:00:00 | 08:47:19 | Iridium Call Forward Iridium | 881662990000 |  | 0.6666666666666666 | Minute |  |  |  | [NAME] | BGAN Telephone Mobile to mobile to BGAN | 9
 | Iridium | 881621467533 | 2023-10-10 00:00:00 | 18:20:23 | Iridium Voice Terrestrial | 19168329101 | USA | 0.3333333333333333 | Minute |  |  |  | [NAME] | [NAME] Voice Originating Call BGAN BGAN | 10
 | Iridium | 881621467533 | 2023-10-15 00:00:00 | 21:20:53 | Iridium Voice Terrestrial | 19287577744 | USA | 0.6666666666666666 | Minute |  |  |  | [NAME] | [NAME] Voice Originating Call BGAN Cellular | 11
 | Iridium | 881621467533 | 2023-10-15 00:00:00 | 21:20:57 | Iridium SMS Iridium | 881662900005 |  | 1 | SMS |  |  |  | [NAME] | [NAME] Voice Originating Call BGAN Fixed | 12
 | Iridium | 881622480389 | 2023-10-04 00:00:00 | 18:43:45 | Iridium SMS Iridium | 881662900005 |  | 1 | SMS |  |  |  | [NAME] | [NAME] Voice Originating Call BGAN Thuraya | 13
 | Iridium | 881622480389 | 2023-10-04 00:00:00 | 18:43:50 | Iridium SMS Iridium | 881662900005 |  | 1 | SMS |  |  |  | [NAME] | [NAME] Voice [NAME] | 14
 | Iridium | 881621458932 | 2023-10-03 00:00:00 | 08:28:49 | Iridium Voice Terrestrial | 442088243434 | GBR | 2 | Minute |  |  |  | [NAME] | Event | 15
 | Iridium | 881623450419 | 2023-10-01 00:00:00 | 02:58:21 | Iridium Voice Terrestrial | 16509606948 | USA | 0.3333333333333333 | Minute |  |  |  | [NAME] | Interactive IP | 16
 | Iridium | 881623476367 | 2023-10-09 00:00:00 | 14:32:48 | Iridium Voice Terrestrial | 442088243434 | GBR | 1 | Minute |  |  |  | [NAME] | MB | 17
 | SatCollect | 13142750211 | 2023-10-28 00:00:00 | 15:12:00 | SatCollect Iridium | 13144617433 | United States | 0.33 | Minute |  |  |  | [NAME] | Minutes | 18
 | SatCollect | 13143705594 | 2023-10-09 00:00:00 | 12:07:00 | SatCollect Iridium | 16362746958 | United States | 0.45 | Minute |  |  |  | [NAME] | SMS MO | 19
 | SatCollect | 13143705594 | 2023-10-09 00:00:00 | 16:07:00 | SatCollect Iridium | 16362746958 | United States | 0.45 | Minute |  |  |  | IRIDIUM | Iridium 2Stage F2M | 20
 | SatCollect | 13143705594 | 2023-10-16 00:00:00 | 11:58:00 | SatCollect Iridium | 15732551129 | United States | 0.33 | Minute |  |  |  | IRIDIUM | 2Stage F2M Iridium | 21
 | Iridium | 881623476055 | 2023-10-10 00:00:00 | 15:40:35 | Iridium Voice Terrestrial | 18043570600 | USA | 0.3333333333333333 | Minute |  |  |  | IRIDIUM | Iridium Call Forward Iridium | 22
 | OpenPort | 881677740870 | 2023-10-09 00:00:00 | 13:41:08 | Basic Voice - Iridium OpenPort Voice to Iridium OpenPort | 18035131115 | USA | 0.3333333333333333 | Minute |  |  |  | IRIDIUM | Data Iridium | 23
 | SatCollect | 12526565022 | 2023-10-19 00:00:00 | 10:11:00 | SatCollect Iridium | 12523091423 | United States | 0.33 | Minute |  |  |  | IRIDIUM | Data Terrestrial | 24
 | SatCollect | 12526565022 | 2023-10-19 00:00:00 | 14:11:00 | SatCollect Iridium | 12523091423 | United States | 0.33 | Minute |  |  |  | IRIDIUM | Iridium / Iridium | 25
 | SatCollect | 19108300605 | 2023-10-17 00:00:00 | 13:53:00 | SatCollect Iridium | 17079405611 | United States | 0.7666666666666667 | Minute |  |  |  | IRIDIUM | Iridium GO! Direct Internet | 26
 | SatCollect | 19802853306 | 2023-10-19 00:00:00 | 09:00:00 | SatCollect Iridium | 19803167295 | United States | 0.33 | Minute |  |  |  | IRIDIUM | Iridium Test | 27
 | SatCollect | 19802853306 | 2023-10-19 00:00:00 | 10:30:00 | SatCollect Iridium | 17043137148 | United States | 0.7833333333333333 | Minute |  |  |  | IRIDIUM | Iridium:Free Call | 28
 | SatCollect | 19802853306 | 2023-10-19 00:00:00 | 13:00:00 | SatCollect Iridium | 19803167295 | United States | 0.33 | Minute |  |  |  | IRIDIUM | Iridium:Iridium | 29
 | SatCollect | 19802853306 | 2023-10-19 00:00:00 | 14:30:00 | SatCollect Iridium | 17043137148 | United States | 0.7833333333333333 | Minute |  |  |  | IRIDIUM | Iridium:PSTN | 30
 | SatCollect | 19802853306 | 2023-10-20 00:00:00 | 08:39:00 | SatCollect Iridium | 19803465056 | United States | 0.33 | Minute |  |  |  | IRIDIUM | Iridium:SMS | 31
 | SatCollect | 19802853306 | 2023-10-20 00:00:00 | 12:39:00 | SatCollect Iridium | 19803465056 | United States | 0.33 | Minute |  |  |  | IRIDIUM | Iridium:Two Stage Dialling | 32
 | SatCollect | 19802853306 | 2023-10-23 00:00:00 | 08:24:00 | SatCollect Iridium | 19803465056 | United States | 0.33 | Minute |  |  |  | IRIDIUM | Iridium:[NAME] | 33
 | SatCollect | 19802853306 | 2023-10-23 00:00:00 | 12:24:00 | SatCollect Iridium | 19803465056 | United States | 0.33 | Minute |  |  |  | IRIDIUM | SMS | 34
 | SatCollect | 19802853306 | 2023-10-24 00:00:00 | 14:33:00 | SatCollect Iridium | 19803466870 | United States | 0.33 | Minute |  |  |  | IRIDIUM | SMS Cellular | 35
 | SatCollect | 19802853306 | 2023-10-24 00:00:00 | 18:33:00 | SatCollect Iridium | 19803466870 | United States | 0.33 | Minute |  |  |  | IRIDIUM | Iridium SMS Iridium | 36
 | SatCollect | 19802853306 | 2023-10-27 00:00:00 | 08:58:00 | SatCollect Iridium | 19803466870 | United States | 0.33 | Minute |  |  |  | IRIDIUM | Iridium SMS Terrestrial | 37
 | SatCollect | 19802853306 | 2023-10-27 00:00:00 | 12:58:00 | SatCollect Iridium | 19803466870 | United States | 0.33 | Minute |  |  |  | IRIDIUM | Iridium Voice Iridium | 38
 | SatCollect | 19802853306 | 2023-10-28 00:00:00 | 19:13:00 | SatCollect Iridium | 19803167295 | United States | 0.33 | Minute |  |  |  | IRIDIUM | Iridium Voice Cellular | 39
 | SatCollect | 19802853306 | 2023-10-30 00:00:00 | 12:41:00 | SatCollect Iridium | 19803466870 | United States | 0.33 | Minute |  |  |  | IRIDIUM | Iridium Voice Iridium Test | 40
 | SatCollect | 19802853306 | 2023-10-31 00:00:00 | 14:06:00 | SatCollect Iridium | 19803167295 | United States | 0.33 | Minute |  |  |  | IRIDIUM | Iridium Voice Terrestrial | 41
 | SatCollect | 19802853306 | 2023-10-31 00:00:00 | 23:39:00 | SatCollect Iridium | 19803167295 | United States | 0.33 | Minute |  |  |  | IRIDIUM | Voice Thuraya | 42
 | SatCollect | 19802853650 | 2023-10-02 00:00:00 | 16:22:00 | SatCollect Iridium | 18773646193 | United States | 0.33 | Minute |  |  |  | IRIDIUM | Iridium Certus:Iridium IP Data | 43
 | Iridium | 881623459127 | 2023-10-27 00:00:00 | 17:16:39 | Iridium Call Forward Iridium | 881662990000 |  | 0.6666666666666666 | Minute |  |  |  | ISAT | Basic Voice - IsatPhone (GSPS) / PSTN | 44
 | Iridium | 881623459127 | 2023-10-30 00:00:00 | 13:41:57 | Iridium Call Forward Iridium | 881662990000 |  | 0.3333333333333333 | Minute |  |  |  | ISAT | Basic voice - IsatPhone (GSPS) to SPS / GSPS | 45
 | SatCollect | 19108278502 | 2023-10-17 00:00:00 | 10:06:00 | SatCollect SMS | 881623415376msgiridiumcom |  | 1 | SMS |  |  |  | ISAT | GSPS Voice:Cellular | 46
 | SatCollect | 19108278502 | 2023-10-20 00:00:00 | 09:48:00 | SatCollect Iridium | 18143450184 | United States | 0.33 | Minute |  |  |  | ISAT | GSPS Voice:Fixed | 47
 | SatCollect | 14702401167 | 2023-10-03 00:00:00 | 09:29:00 | SatCollect Iridium | 12292858210 | United States | 0.3333333333333333 | Minute |  |  |  | ISAT | GSPS Voice:Fixed North America (In) | 48
 | SatCollect | 14702401167 | 2023-10-03 00:00:00 | 13:29:00 | SatCollect Iridium | 12292858210 | United States | 0.3333333333333333 | Minute |  |  |  | ISAT | GSPS Voice:GSPS SMS | 49
 | SatCollect | 16788000633 | 2023-10-20 00:00:00 | 12:37:00 | SatCollect Iridium | 17065953695 | United States | 0.85 | Minute |  |  |  | ISAT | GSPS Voice:Iridium | 50
 | SatCollect | 16788000633 | 2023-10-20 00:00:00 | 16:37:00 | SatCollect Iridium | 17065953695 | United States | 0.85 | Minute |  |  |  | ISAT | GSPS:Free Call | 51
 | SatCollect | 14702321278 | 2023-10-13 00:00:00 | 11:11:00 | SatCollect Iridium | 14709704024 | United States | 0.8166666666666667 | Minute |  |  |  | ISAT | In Region Voice - IsatPhone Pro to PSTN | 52
 | SatCollect | 14702321278 | 2023-10-13 00:00:00 | 15:11:00 | SatCollect Iridium | 14709704024 | United States | 0.8166666666666667 | Minute |  |  |  | ISAT | Voice Terrestrial | 53
 | SatCollect | 14702321278 | 2023-10-25 00:00:00 | 17:48:00 | SatCollect Iridium | 17624751975 | United States | 0.33 | Minute |  |  |  | ISAT | Voice Cellular | 54
 | SatCollect | 14702320106 | 2023-10-17 00:00:00 | 14:13:00 | SatCollect Iridium | 14784122544 | United States | 0.4166666666666667 | Minute |  |  |  | ISAT | Voice Inmarsat I4 | 55
 | SatCollect | 14702320106 | 2023-10-17 00:00:00 | 18:13:00 | SatCollect Iridium | 14784122544 | United States | 0.4166666666666667 | Minute |  |  |  | OPENPORT | Iridium OpenPort Data | 56
 | SatCollect | 16783173169 | 2023-10-05 00:00:00 | 00:23:00 | SatCollect Iridium | 16786422323 | United States | 0.4833333333333333 | Minute |  |  |  | OPENPORT | Basic Voice - Iridium OpenPort Voice to Iridium OpenPort | 57
 | SatCollect | 16783173169 | 2023-10-05 00:00:00 | 00:26:00 | SatCollect Iridium | 16786422323 | United States | 0.8666666666666667 | Minute |  |  |  | OPENPORT | Basic Voice - Iridium OpenPort Voice to PSTN | 58
 | Iridium | 881621458408 | 2023-10-07 00:00:00 | 15:24:10 | Iridium Voice Terrestrial | 15089541410 | USA | 0.3333333333333333 | Minute |  |  |  | MSAT | MSAT_INCOMING | 59
 | Iridium | 881621458408 | 2023-10-07 00:00:00 | 18:02:15 | Iridium Voice Terrestrial | 12036876123 | USA | 0.3333333333333333 | Minute |  |  |  | MSAT | [NAME] | 60
 | Iridium | 881621458408 | 2023-10-10 00:00:00 | 13:30:49 | Iridium Voice Terrestrial | 12074330660 | USA | 1.666666666666667 | Minute |  |  |  | SATCOLLECT | SatCollect Inmarsat BGan | 61
 | SatCollect | 13302695319 | 2023-10-01 00:00:00 | 05:48:00 | SatCollect Iridium | 18032215066 | United States | 0.6166666666666667 | Minute |  |  |  | SATCOLLECT | SatCollect Iridium | 62
 | SatCollect | 13302695319 | 2023-10-01 00:00:00 | 09:48:00 | SatCollect Iridium | 18032215066 | United States | 0.6166666666666667 | Minute |  |  |  | SATCOLLECT | SatCollect SMS | 63
 | MSAT | 5007582125 | 2023-10-02 00:00:00 | 09:58:32 | [NAME] | 7242192035 | United States | 2 | Minute |  |  |  | THURAYA | Thuraya:Band1 | 64
 | MSAT | 5007582125 | 2023-10-02 00:00:00 | 10:32:25 | [NAME] | 7242192035 | United States | 2 | Minute |  |  |  | THURAYA | Thuraya:Band2 | 65
 | MSAT | 5007582125 | 2023-10-05 00:00:00 | 08:56:01 | [NAME] | 7242192035 | United States | 4 | Minute |  |  |  | THURAYA | Thuraya:Band3 | 66
 | SatCollect | 18552015952 | 2023-10-17 00:00:00 | 14:16:00 | SatCollect Iridium | 18152856006 | United States | 0.6 | Minute |  |  |  | THURAYA | Thuraya:Free Call | 67
 | SatCollect | 18552015952 | 2023-10-17 00:00:00 | 18:16:00 | SatCollect Iridium | 18152856006 | United States | 0.6 | Minute |  |  |  | THURAYA | Thuraya:Thuraya | 68
 | Iridium | 881652417714 | 2023-10-17 00:00:00 | 18:17:19 | Iridium Call Forward Iridium | 881662990000 |  | 1.333333333333333 | Minute |  |  |  | THURAYA | Thuraya:Thuraya SMS | 69
 | Iridium | 881652417714 | 2023-10-17 00:00:00 | 18:22:41 | Iridium Voice Iridium Test | 14807525105 | USA | 0.1666666666666667 | Minute
 | Iridium | 881631445524 | 2023-10-31 00:00:00 | 02:07:40 | Iridium Voice Terrestrial | 19073557847 | USA | 3 | Minute
 | Iridium | 881693701404 | 2023-10-04 00:00:00 | 18:27:52 | Iridium Voice Cellular | 5213117408985 | MEX | 1 | Minute
 | Iridium | 881693701404 | 2023-10-23 00:00:00 | 14:57:01 | Iridium Voice Terrestrial | 15735798838 | USA | 1.333333333333333 | Minute
 | Iridium | 881621454139 | 2023-10-03 00:00:00 | 14:31:41 | Iridium Voice Terrestrial | 15713453146 | USA | 0.3333333333333333 | Minute
 | SatCollect | 14805355559 | 2023-10-17 00:00:00 | 12:27:00 | SatCollect Iridium | 19283617809 | United States | 0.33 | Minute
 | SatCollect | 14805355559 | 2023-10-17 00:00:00 | 16:27:00 | SatCollect Iridium | 19283617809 | United States | 0.33 | Minute
 | SatCollect | 14805465584 | 2023-10-11 00:00:00 | 13:20:00 | SatCollect SMS | 881623422702msgiridiumcom |  | 1 | SMS
 | SatCollect | 14805465584 | 2023-10-11 00:00:00 | 13:20:00 | SatCollect SMS | 881623422702msgiridiumcom |  | 1 | SMS
 | Iridium | 881623476654 | 2023-10-27 00:00:00 | 15:30:26 | Iridium Voice Terrestrial | 18046742400 | USA | 2 | Minute
 | Iridium | 881652440563 | 2023-10-01 00:00:00 | 17:03:11 | Iridium SMS Terrestrial | 18047256047 | USA | 1 | SMS
 | Iridium | 881652440563 | 2023-10-04 00:00:00 | 00:19:34 | Iridium SMS Terrestrial | 17578709286 | USA | 1 | SMS
 | SatCollect | 18043814600 | 2023-10-03 00:00:00 | 12:27:00 | SatCollect Iridium | 17576933036 | United States | 0.33 | Minute
 | SatCollect | 18043814600 | 2023-10-03 00:00:00 | 16:27:00 | SatCollect Iridium | 17576933036 | United States | 0.33 | Minute
 | Iridium | 881641403156 | 2023-10-02 00:00:00 | 08:15:44 | Iridium Voice Cellular | 6785577890 | VUT | 2.333333333333333 | Minute
 | Iridium | 881641403156 | 2023-10-02 00:00:00 | 08:20:10 | Iridium Voice Cellular | 6785577890 | VUT | 1.666666666666667 | Minute
 | SatCollect | 17864041816 | 2023-10-04 00:00:00 | 17:12:00 | SatCollect Iridium | 12392343479 | United States | 0.33 | Minute
 | SatCollect | 17864041816 | 2023-10-04 00:00:00 | 21:12:00 | SatCollect Iridium | 12392343479 | United States | 0.33 | Minute