+ Reply to Thread
Results 1 to 4 of 4

Showing indexed content

  1. #1
    Registered User
    Join Date
    01-23-2012
    Location
    Rome, Italy
    MS-Off Ver
    Excel 2007
    Posts
    2

    Showing indexed content

    Before I start, let me say I haven't found n answer so far. I probably used the wrong search string. The question is simple and I hope the solution will be too, as I am not an experienced coder. I have a table with two columns. The first one contains country names (e.g. Greece), the second the associated country code (e.g. CX045). I would like to type the country name in one cell, press enter and see the country code appear in the cell nearby. Is there any function to browse the table and get the code I want when the input text matches?
    Thanks for any piece of advice.

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,186

    Re: Showing indexed content

    Have a look at the VLookup function

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,534

    Re: Showing indexed content

    Hi altotoe and welcome to the forum,

    You are looking for a simple VLookup formula.
    Watch this video http://www.youtube.com/watch?v=2wHtcct7mCE and it will show a few ways to use VLookup.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    01-23-2012
    Location
    Rome, Italy
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Showing indexed content

    This exactly what I needed!! Thank you veeery much!

+ 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