I am trying to use Index and Match to lookup a 3 letter code in a list I am compiling and have it match a corresponding 3 letter code and a corresponding 4 letter code in a master list.
I am looking up airport codes, and the lookup doesn't seem to do the job exactly matching the codes...
I am having no luck with this formula
=INDEX(paid50!A:A,MATCH(B3,paid50!B:B,0))
I have a sheet named mergeIATAdb with the columns
Column B......Column C
IATA_name...ICAO_name...(I want to use Index and Match to fill in ICAO)
AAB..............
AAE..............
ABE..............
Sheet named paid50 (This sheet is my master list with all the airports)
Column B......Column C......Column D
IATA_name...ICAO_name...Airport_name
AAB..............YARY............Queensland
AAE..............DABB............Mellah
ABE..............KABE............Allentown
I am looking up airport codes, and the lookup doesn't seem to do the job exactly matching the codes...
I am having no luck with this formula
=INDEX(paid50!A:A,MATCH(B3,paid50!B:B,0))
I have a sheet named mergeIATAdb with the columns
Column B......Column C
IATA_name...ICAO_name...(I want to use Index and Match to fill in ICAO)
AAB..............
AAE..............
ABE..............
Sheet named paid50 (This sheet is my master list with all the airports)
Column B......Column C......Column D
IATA_name...ICAO_name...Airport_name
AAB..............YARY............Queensland
AAE..............DABB............Mellah
ABE..............KABE............Allentown