You could use the Vlookup function.

Check out Debra Dalgleish's web page on the subject:

http://www.contextures.com/xlFunctions02.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Thom" wrote in message
...
I am trying to figure out how to reference a list on a seperate worksheet.
I
have a list of Airport Codes, with the corresponding city next to it.

On a seperate worksheet, I would like to be able to enter the three-letter
airport code, and have the city pop up automatically next to it.

Any advice? Thanks!