Spreadsheet: 841042d1693299566-unable-to-use-vlookup-or-function-to-match-two-data-set-mid-function-1-
Sheet: TST

CODE | LEN | MID Function
SYD NZ AKL |  |  |  | AKL
DEL AI SYD 1A |  |  |  | SYD
MEL UL CMB UL MEL |  |  |  | CMB | [NAME]
SYD UL CMB//SYD 1A |  |  |  | CMB | SYD
MXP VY BCN // VY IBZ |  |  |  | BCN | IBZ
DEL UL CMB UL SYD 1A |  |  |  | CMB | SYD
DXB EK MED//JED EK DXB |  |  |  | MED | JED | DXB
MEL UL CMB UL SIN UL MEL |  |  |  | CMB | SIN | [NAME]
DEL TG BKK TG MEL//SYD 1A |  |  |  | BKK | [NAME] | SYD
[NAME] // [NAME] |  |  |  | SIN | KUL | [NAME]
CMB QF SIN QF SYD QF ASP 1A |  |  |  | SIN | SYD | ASP
[NAME] BKK TG NRT//CTS TG BKK |  |  |  | BKK | NRT | CTS | BKK
CMB UL MEL YY HAVE A SAFE TRIP |  |  |  | [NAME]
SYD LA SCL LA EZE LA SCL LA SYD |  |  |  | SCL | EZE | SCL | SYD
MAA DL CDG DL YYZ WS YYC//DTW 1A |  |  |  | CDG | YYZ | YYC | DTW
SYD QF LHR QF SIN 3K HKT // QF SYD |  |  |  | LHR | SIN | HKT | SYD
SYD EK DXB EK MLA//ATH EK DXB EK SYD |  |  |  | DXB | [NAME] | ATH | DXB | SYD
DXB BI BWN BI [NAME] HAVE A SAFE TRIP |  |  |  | BWN | [NAME]
OOL VA MEL QR DOH QR IKA QR DOH QR MEL |  |  |  | [NAME] | DOH | IKA | DOH | [NAME]
MEL UL CMB UL LHE UL CMB UL MEL//SYD 1A |  |  |  | CMB | LHE | CMB | [NAME] | SYD
SYD CI TPE//TSA CI HND//NRT CI TPE CI SYD |  |  |  | TPE | TSA | HND | NRT | TPE | SYD
SYD UL MEL UL CMB UL LHE UL CMB UL SYD 1A |  |  |  | [NAME] | CMB | LHE | CMB | SYD
SYD JL HND JL HEL AY AMS//CDG JL HND JL SYD |  |  |  | HND | HEL | AMS | CDG | HND | SYD
MKY QF BNE QF SIN AI DEL QF MEL QF BNE QF MKY |  |  |  | BNE | SIN | DEL | [NAME] | BNE | MKY
JNB 4Z HDS//MQP 4Z LVI//VFA 4Z CPT//PLZ 4Z JNB |  |  |  | HDS | MQP | LVI | VFA | CPT | PLZ | JNB
SYD QF DFW QF BWI//JFK BA [NAME] OSL//LHR BA SYD |  |  |  | DFW | BWI | [NAME] | LHR | OSL | LHR | SYD
[NAME] OD KUL WY MCT WY JED//MED WY MCT WY KUL OD MEL |  |  |  | KUL | MCT | JED | MED | MCT | KUL | [NAME]
MEL BI BWN BI DXB BI BWN BI [NAME] HAVE A SAFE TRIP |  |  |  | BWN | DXB | BWN | [NAME]
CBR QF MEL QF SIN EK DXB EK LIS EK DXB EK MEL EK CBR |  |  |  | [NAME] | SIN | DXB | LIS | DXB | [NAME] | CBR
[NAME] ISB//KHI EK DXB [NAME] |  |  |  | DXB | MED | JED | DXB | ISB | KHI | DXB | [NAME]
SYD TK SIN TK IST TK ZAG OU SPU//ZAG TK IST TK SIN TK SYD |  |  |  | SIN | IST | ZAG | SPU | ZAG | IST | SIN | SYD
ADL VA SYD AC YVR AC YYZ AC YQM AC YYZ AC YVR AC SYD VA ADL |  |  |  | SYD | YVR | YYZ | YQM | YYZ | YVR | SYD | ADL
SYD QF HND//NRT LX ZRH LX MAD//LIS [NAME] EWR//JFK QF SYD |  |  |  | HND | NRT | ZRH | MAD | LIS | ZRH | EWR | [NAME] | SYD
SYD QF [NAME] FRA LH SVQ//TLV [NAME] LX NRT//HND QF SYD QF PER |  |  |  | JNB | FRA | SVQ | TLV | ZRH | NRT | HND | SYD | PER
SYD LH SIN LH FRA LH VNO//TLL LH [NAME] CAI LH FRA LH SIN SQ SYD |  |  |  | SIN | FRA | VNO | TLL | FRA | CAI | FRA | SIN | SYD
MKY VA BNE UA SYD UA IAH UA LIM UA IAH UA LAX UA SYD VA BNE VA MKY |  |  |  | BNE | SYD | IAH | LIM | IAH | LAX | SYD | BNE | MKY
ADL EK MEL EK DXB EK NJF//MHD EK DXB EK MED//JED EK DXB [NAME] |  |  |  | [NAME] | DXB | NJF | MHD | DXB | MED | JED | DXB | [NAME] | ADL
PER UL SIN UL CMB UL KHI UL CMB UL SIN UL PER//MEL YY HAVE A SAFE TRIP |  |  |  | SIN | CMB | KHI | CMB | SIN | PER | [NAME]
BWT QF MEL FJ NAN FJ TRW FJ NAN//SUV FJ FUN FJ SUV FJ NAN FJ MEL QF BWT |  |  |  | [NAME] | NAN | TRW | NAN | SUV | FUN | SUV | NAN | [NAME] | BWT
MEL QF SIN ET ADD ET JED ET ADD ET ASM ET ADD ET NBO ET ADD ET KUL MH MEL |  |  |  | SIN | ADD | JED | ADD | ASM | ADD | NBO | ADD | KUL | [NAME]
SYD QF SIN MH KUL MH NRT JL HKG CX TLV//AMS AA PHL AA DCA AS SFO//LAX QF SYD |  |  |  | SIN | KUL | NRT | HKG | TLV | AMS | PHL | DCA | SFO | LAX | SYD
CBR QF SYD QF LAX QF ORD QF YYZ//JFK AY HEL AY PRG AY HEL AY SIN QF MEL QF CBR |  |  |  | SYD | LAX | ORD | YYZ | [NAME] | HEL | PRG | HEL | SIN | [NAME] | CBR
SYD QF SIN MH KUL MH MAA//DEL QR DOH QR BER//AMS AA PHL AA DCA//PHL QF LAX QF SYD |  |  |  | SIN | KUL | MAA | DEL | DOH | BER | AMS | PHL | DCA | PHL | LAX | SYD
MCY QF SYD QF SIN MH KUL MH NRT JL HKG CX TLV//AMS AA PHL AA DCA AS SFO//LAX QF BNE |  |  |  | SYD | SIN | KUL | NRT | HKG | TLV | AMS | PHL | DCA | SFO | LAX | BNE
PER QF SIN QF LHR//CDG AA DFW AA AUS AA RDU AA JFK AA LAX BA NAN FJ CHC QF MEL QF PER |  |  |  | SIN | LHR | CDG | DFW | AUS | RDU | [NAME] | LAX | NAN | CHC | [NAME] | PER
WGA QF SYD QF SIN MH KUL MH MAA//DEL QR DOH QR BER//AMS AA PHL AA DCA//DFW QF SYD QF WGA |  |  |  | SYD | SIN | KUL | MAA | DEL | DOH | BER | AMS | PHL | DCA | DFW | SYD | WGA
ADL UA MEL UA SFO UA MSY UA IAH UA FLL//MIA UA EWR UA LHR//MAN SQ SIN SQ HKT SQ SIN SQ ADL |  |  |  | [NAME] | SFO | MSY | IAH | FLL | MIA | EWR | LHR | MAN | SIN | HKT | SIN | ADL
PER QF SIN MH KUL MH MAA//DEL QR DOH QR BER//AMS AA PHL AA DCA//PHL AA YYZ//SFO QF SYD QF PER |  |  |  | SIN | KUL | MAA | DEL | DOH | BER | AMS | PHL | DCA | PHL | YYZ | SFO | SYD | PER
NRT JL SIN MH KUL MH MAA//DEL QR DOH QR BER//AMS AA PHL AA DCA//PHL AA PHX AA SMF JL LAX JL HND |  |  |  | SIN | KUL | MAA | DEL | DOH | BER | AMS | PHL | DCA | PHL | PHX | SMF | LAX | HND
AKL QF SYD QF SIN MH KUL MH NRT JL HKG CX TLV//AMS AA PHL AA DCA//FAT AA PHX AA LAX QF MEL QF AKL |  |  |  | SYD | SIN | KUL | NRT | HKG | TLV | AMS | PHL | DCA | FAT | PHX | LAX | [NAME] | AKL
HBA QF SYD QF SIN MH KUL MH NRT JL HKG CX TLV//AMS AA PHL AA DCA AS SFO//FAT AA PHX AA LAX QF SYD QF |  |  |  | SYD | SIN | KUL | NRT | HKG | TLV | AMS | PHL | DCA | SFO | FAT | PHX | LAX | SYD