+ Reply to Thread
Results 1 to 3 of 3

How to auto-fill text based on text in another cell

  1. #1
    Jason
    Guest

    How to auto-fill text based on text in another cell

    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

  2. #2
    Jason Morin
    Guest

    Re: How to auto-fill text based on text in another cell

    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
    >.
    >


  3. #3
    Gord Dibben
    Guest

    Re: How to auto-fill text based on text in another cell

    Jason

    Probably VLOOKUP could work for you.

    Assume your table of abbreviations and cities are in M1:N10

    In C1 enter =VLOOKUP(B1,$M$1:$N$10,2,0)

    Enter CHS in B1 to return Chareston in C1.

    You could also turn B1 into a drop-down list so's you could just pick the
    abbreviation, not type it.

    Select B1 then Data>Validation>List. Select M1:M10 as your list.


    Gord Dibben Excel MVP

    On Wed, 16 Feb 2005 10:59:04 -0800, "Jason" <Jason@discussions.microsoft.com>
    wrote:

    >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



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1