looking up a value

Find attached. There will be more clever ways of doing this but I have kept the formula really simple and modified your "list with ap" somewhat.

You will see that next to the "LUX" entry you get #N/A - this is because the LUX code doesn't appear in your list. To avoid this error you could use an IFERROR forumula, e.g.

=IFERROR(VLOOKUP(A2,airport_codes,2,FALSE),"no area available")

in B2 and copy down to B7