Spreadsheet: 841048d1693304182-unable-to-use-vlookup-or-function-to-match-two-data-set-mid-function-2-aligw
Sheet: Sheet1

SYD NZ AKL |  |  |  |  |  |  |  | 10 | 8
DEL AI SYD 1A |  |  |  |  |  |  |  | 14 | 8
MEL UL CMB UL MEL |  |  |  |  |  |  |  | 17 | 8
SYD UL CMB//SYD 1A |  |  |  |  |  |  |  | 19 | 8
MXP VY BCN // VY IBZ |  |  |  |  |  |  |  | 20 | 8
DEL UL CMB UL SYD 1A |  |  |  |  |  |  |  | 21 | 8
DXB EK MED//JED EK DXB |  |  |  |  |  |  |  | 22 | 8
MEL UL CMB UL SIN UL MEL |  |  |  |  |  |  |  | 24 | 8
DEL TG BKK TG MEL//SYD 1A |  |  |  |  |  |  |  | 26 | 15
[NAME] // [NAME] |  |  |  |  |  |  |  | 27 | 15
CMB QF SIN QF SYD QF ASP 1A |  |  |  |  |  |  |  | 28 | 15
[NAME] BKK TG NRT//CTS TG BKK |  |  |  |  |  |  |  | 29 | 15
CMB UL MEL YY HAVE A SAFE TRIP |  |  |  |  |  |  |  | 30 | 8
SYD LA SCL LA EZE LA SCL LA SYD |  |  |  |  |  |  |  | 31 | 8
MAA DL CDG DL YYZ WS YYC//DTW 1A |  |  |  |  |  |  |  | 33 | 15
SYD QF LHR QF SIN 3K HKT // QF SYD |  |  |  |  |  |  |  | 34 | 8
SYD EK DXB EK MLA//ATH EK DXB EK SYD |  |  |  |  |  |  |  | 36 | 15
DXB BI BWN BI [NAME] HAVE A SAFE TRIP |  |  |  |  |  |  |  | 37 | 15
OOL VA MEL QR DOH QR IKA QR DOH QR MEL |  |  |  |  |  |  |  | 38 | 22
MEL UL CMB UL LHE UL CMB UL MEL//SYD 1A |  |  |  |  |  |  |  | 40 | 15
SYD CI TPE//TSA CI HND//NRT CI TPE CI SYD |  |  |  |  |  |  |  | 41 | 25
SYD UL MEL UL CMB UL LHE UL CMB UL SYD 1A |  |  |  |  |  |  |  | 42 | 22
SYD JL HND JL HEL AY AMS//CDG JL HND JL SYD |  |  |  |  |  |  |  | 43 | 22
MKY QF BNE QF SIN AI DEL QF MEL QF BNE QF MKY |  |  |  |  |  |  |  | 45 | 22
JNB 4Z HDS//MQP 4Z LVI//VFA 4Z CPT//PLZ 4Z JNB |  |  |  |  |  |  |  | 46 | 25
SYD QF DFW QF BWI//JFK BA [NAME] OSL//LHR BA SYD |  |  |  |  |  |  |  | 48 | 20
[NAME] OD KUL WY MCT WY JED//MED WY MCT WY KUL OD MEL |  |  |  |  |  |  |  | 50 | 15
MEL BI BWN BI DXB BI BWN BI [NAME] HAVE A SAFE TRIP |  |  |  |  |  |  |  | 51 | 15
CBR QF MEL QF SIN EK DXB EK LIS EK DXB EK MEL EK CBR |  |  |  |  |  |  |  | 52 | 29
[NAME] ISB//KHI EK DXB [NAME] |  |  |  |  |  |  |  | 55 | 15
SYD TK SIN TK IST TK ZAG OU SPU//ZAG TK IST TK SIN TK SYD |  |  |  |  |  |  |  | 57 | 15
ADL VA SYD AC YVR AC YYZ AC YQM AC YYZ AC YVR AC SYD VA ADL |  |  |  |  |  |  |  | 59 | 15
SYD QF HND//NRT LX ZRH LX MAD//LIS [NAME] EWR//JFK QF SYD |  |  |  |  |  |  |  | 60 | 20
SYD QF [NAME] FRA LH SVQ//TLV [NAME] LX NRT//HND QF SYD QF PER |  |  |  |  |  |  |  | 62 | 22
SYD LH SIN LH FRA LH VNO//TLL LH [NAME] CAI LH FRA LH SIN SQ SYD |  |  |  |  |  |  |  | 64 | 22
MKY VA BNE UA SYD UA IAH UA LIM UA IAH UA LAX UA SYD VA BNE VA MKY |  |  |  |  |  |  |  | 66 | 22
ADL EK MEL EK DXB EK NJF//MHD EK DXB EK MED//JED EK DXB [NAME] |  |  |  |  |  |  |  | 69 | 22
PER UL SIN UL CMB UL KHI UL CMB UL SIN UL PER//MEL YY HAVE A SAFE TRIP |  |  |  |  |  |  |  | 70 | 22
BWT QF MEL FJ NAN FJ TRW FJ NAN//SUV FJ FUN FJ SUV FJ NAN FJ MEL QF BWT |  |  |  |  |  |  |  | 71 | 22
MEL QF SIN ET ADD ET JED ET ADD ET ASM ET ADD ET NBO ET ADD ET KUL MH MEL |  |  |  |  |  |  |  | 73 | 29
SYD QF SIN MH KUL MH NRT JL HKG CX TLV//AMS AA PHL AA DCA AS SFO//LAX QF SYD |  |  |  |  |  |  |  | 76 | 29
CBR QF SYD QF LAX QF ORD QF YYZ//JFK AY HEL AY PRG AY HEL AY SIN QF MEL QF CBR |  |  |  |  |  |  |  | 78 | 29
SYD QF SIN MH KUL MH MAA//DEL QR DOH QR BER//AMS AA PHL AA DCA//PHL QF LAX QF SYD |  |  |  |  |  |  |  | 81 | 22
MCY QF SYD QF SIN MH KUL MH NRT JL HKG CX TLV//AMS AA PHL AA DCA AS SFO//LAX QF BNE |  |  |  |  |  |  |  | 83 | 22
PER QF SIN QF LHR//CDG AA DFW AA AUS AA RDU AA JFK AA LAX BA NAN FJ CHC QF MEL QF PER |  |  |  |  |  |  |  | 85 | 20
WGA QF SYD QF SIN MH KUL MH MAA//DEL QR DOH QR BER//AMS AA PHL AA DCA//DFW QF SYD QF WGA |  |  |  |  |  |  |  | 88 | 29
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 |  |  |  |  |  |  |  | 90 | 29
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 |  |  |  |  |  |  |  | 93 | 27
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 |  |  |  |  |  |  |  | 95 | 27
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 |  |  |  |  |  |  |  | 97 | 29
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 |  |  |  |  |  |  |  | 100 | 29