Spreadsheet: 124039d1318016145-vlookup-ineffective-what-should-i-use-example2-jrchel20
Sheet: Example DD

Outbound Flight |  | Leg No | Outbound Ship No. | Inbound   ETA | Dest | AC Type | [NAME] | Days of Op |  | KRT | CRT | SRT | KDT | ETD | Class | Catering Service |  | Passenger Count |  |  |  | Standb |  | Special Meals |  |  | Comment |  | [NAME], [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prel | Final |  | Conf
AM0641 |  | 10 |  |  | GDL | 73G | 12/12/112 | 4 67 |  |  |  |  |  | 00:10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BC | CMWT |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | CMWT |  | 112
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZH | HAND
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZB | BEVP
DL0806 |  | 10 |  |  | MSP | 73H | 16/16/144 | 6 |  |  |  |  |  | 00:29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC |  |  | 144
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZB
AM0665 |  | 10 |  |  | MEX | 73G | 12/12/112 | 1234567 |  |  |  |  |  | 00:40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BC | CMWT |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | CMWT |  | 112
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZH | HAND
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZB | BEVP
CX0873 |  | 10 |  | 21:55 | HKG | 74A | 9/45/324 | 1234567 |  |  |  |  |  | 01:20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | BEVP, HBNT, HMNT |  | 9 |  |  |  |  |  | VGML-1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BC | BEVP, HBNT, HMNT |  | 45 |  |  |  |  |  | AVML-1, LFML-1, MOML-1, SPML-1, VLML-1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | BEVP, CSNT, HBNT, HMNT |  | 324 |  |  |  |  |  | AVML-11, CHML-2, FPML-1, [NAME], LCML-1, LSML-1, MOML-3, SPML-2, VGML-2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CC | CSWT, HBNT, HMNT |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CY | HBNT, HMNT |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZH | HAND
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZB | BEVP
Outbound Flight |  | Leg No | Outbound Ship No. | Inbound   ETA | Dest | AC Type | [NAME] | Days of Op |  | KRT | CRT | SRT | KDT | ETD | Class | Catering Service |  | Passenger Count |  |  |  | Standb |  | Special Meals |  |  | Comment |  | [NAME], [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prel | Final |  | Conf
BR0017 |  | 10 |  | 16:00 | TPE | 77W | 0/36/211 | 1234567 |  |  |  |  |  | 01:40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BC | HBWT, HMNT, HSWT |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | HBWT, HMNT |  | 211
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EU | HBWT, HMNT |  | 71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CC | HBNT, HMWT |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CY | HBNT, HMWT |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZH | HAND
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZB | BEVP
UA0756 |  | 10 |  |  | DEN | MD | 34/0/210 | 6 |  |  |  |  |  | 05:42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | B05 |  | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | [NAME] |  | 210
DL2334 |  | 10 |  |  | SLC | 73H | 16/16/144 | 2   67 |  |  |  |  |  | 06:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC |  |  | 144
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZB
UA0248 |  | 10 |  |  | PHX | AJ | 8/0/112 | 1  456 |  |  |  |  |  | 06:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | R03 |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | V04 |  | 112
UA0248/ UA0952 |  | 20 |  |  | IAD | AJ | 8/0/112
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | B05, R05 |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | V04F, V06R |  | 112
UA0734 |  | 10 |  |  | ORD | MX | 24/0/158 | 6 |  |  |  |  |  | 06:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | B05, R05 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | V04F, V06R |  | 158
DL0906 |  | 10 |  |  | MSP | M9K | 16/16/144 | 6 |  |  |  |  |  | 06:05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | AB |  | 16 |  |  |  |  |  | DBML-1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | EATS |  | 144
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZB
Outbound Flight |  | Leg No | Outbound Ship No. | Inbound   ETA | Dest | AC Type | [NAME] | Days of Op |  | KRT | CRT | SRT | KDT | ETD | Class | Catering Service |  | Passenger Count |  |  |  | Standb |  | Special Meals |  |  | Comment |  | [NAME], [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prel | Final |  | Conf
UA0452 |  | 10 |  |  | LAS | AD | 12/0/132 | 6 |  |  |  |  |  | 06:08
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | R03 |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | V04 |  | 132
UA0261 |  | 10 |  |  | LAX | AJ | 8/0/112 | 6 |  |  |  |  |  | 06:14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | R03 |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | V04 |  | 112
[NAME] |  | 10 |  |  | DEN | 319 | 12/0/136 | 1234567 |  |  |  |  |  | 06:15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | CBWT |  | 136
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZH | HAND
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZB | BEVP
DL1580 |  | 10 |  |  | ATL | 76Q | 30/30/231 | 6 |  |  |  |  |  | 06:20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | AB |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | EATS |  | 231
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZB
DL0030 |  | 10 |  |  | [NAME] | 75E | 0/16/158 | 6 |  |  |  |  |  | 06:30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BC | AE |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | EATS |  | 158
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CC | CREW |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CY | CREW |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZB
UA0286 |  | 10 |  |  | [NAME] | MP | 12/26/72 | 6 |  |  |  |  |  | 06:35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | B03, S09 |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BC | B25, V27 |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | V04F, V06R |  | 72
UA0276 |  | 10 |  |  | SEA | AB | 12/0/126 | 6 |  |  |  |  |  | 06:51
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | R03 |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | V04 |  | 126
UA0276/ UA0698 |  | 20 |  |  | SFO | AB | 12/0/126 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | R03 |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | V04 |  | 126
Outbound Flight |  | Leg No | Outbound Ship No. | Inbound   ETA | Dest | AC Type | [NAME] | Days of Op |  | KRT | CRT | SRT | KDT | ETD | Class | Catering Service |  | Passenger Count |  |  |  | Standb |  | Special Meals |  |  | Comment |  | [NAME], [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prel | Final |  | Conf
DL0854 |  | 10 |  |  | DTW | 75X | 26/26/158 | 1234567 |  |  |  |  |  | 07:05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | AB |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | EATS |  | 158
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZB
UA0794 |  | 10 |  |  | DEN | AB | 12/0/126 | 6 |  |  |  |  |  | 07:29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | B05 |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | [NAME] |  | 126
UA0272 |  | 10 |  |  | LAX | AJ | 8/0/112 | 6 |  |  |  |  |  | 07:30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | R03 |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | V04 |  | 112
UA0904 |  | 10 |  |  | IAH | AJ | 8/0/112 | 6 |  |  |  |  |  | 07:35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | B05 |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | V04F, V06R |  | 112
UA0904/ UA0233 |  | 20 |  |  | SFO | AJ | 8/0/112
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | S05 |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | V06F, V06R |  | 112
UA0914 |  | 10 |  |  | IAD | MQ | 24/0/158 | 6 |  |  |  |  |  | 07:50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | B05, R05 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | V04F, V06R |  | 158
NW1106 |  | 10 |  |  | MSP | 75A | 16/16/150 | 1234567 |  |  |  |  |  | 08:05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | AB |  | 16 |  |  |  |  |  | DBML-1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | EATS |  | 150
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZB
UA0688 |  | 10 |  |  | ORD | AD | 12/0/132 | 6 |  |  |  |  |  | 08:05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FC | B05, R05 |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EC | V04F, V06R |  | 132