looking up a value

hi
following is my question
I have in sheet 1 a table where in colomn/row A1 is my 3 letter code of an Airport (ex. ATL = ATLANTA) + various other entries in different columns.
in a 2nd sheet in same file is a list of the various airports which belong to a certain area.
(ex: column 1 header = Area1 and below listed are all the a/p for this area, column 2 header = Area 2 and below listed are the a/p for this area.

Now: would like to add a formula in my sheet 1 where when I enter the airport 3 letter code in A1, lets say M1 gives me the area based on the list in the 2nd sheet.
so M1 should lookup a1 ckeck my list in sheet 2 and return: either AREA 1, 2, 3 or 4 as output

As I would like to do this retroactive over 3 years and as there are hundreds of records I like to use a formula and not type it record by record.

looking fwd to yr help
thanks
Serge

Serge --
If your 3 letter airport code appears in both sheets then the VLOOKUP formula should solve your problem. If you can't work it out upload a simple example and I am sure that someone will be able to help you out.

Hi DEEMO
pls see a small example attached

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

hey Deemo
This solved my problem!
How cool
many thanks
Serge