One way is to create a table of airport codes and cities,
then use VLOOKUP. See here for instructions:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello,

I need to know how to auto-fill text based on text in
another cell. For
example:

Every time I enter "CHS" in Column B, I want Charleston
to auto-fill in
Column C.
And when I enter "SAN", in Column B, I want San Diego to
auto-fill in Column
C.

How can I set up a list like this? Any ideas?

Thanks!

Jason
.