+ Reply to Thread
Results 1 to 3 of 3

Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice

  1. #1
    Registered User
    Join Date
    01-22-2013
    Location
    Italy
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice

    Hello everyone!!!

    I'm really ''new'' on the Excel 'field', new means I'm really ignorant, but i try my best to do an data-base! So i made different columns: name, phone number, add, city, region, etc. On the city column i made an drop-down with all the city initials.
    My problem is: after i choose the city initials in the ''city'' column, i wish that in the 'region' column will appear in automatically the region name corespondent of the city.
    This are the list:
    City Region
    AG Sicilia
    AL Piemonte
    AN Marche
    AO Valle d'Aosta
    AP Marche
    AQ Abruzzo
    AR Toscana
    AT Piemonte
    AV Campania
    BA Puglia
    BG Lombardia
    BI Piemonte
    BL Veneto
    BN Campania
    BO Emilia-Romagna
    BR Puglia
    BS Lombardia
    BT Puglia
    BZ Trentino-Alto Adige
    CA Sardegna
    CB Molise
    CE Campania
    CH Abruzzo
    CI Sardegna
    CL Sicilia
    CN Piemonte
    CO Lombardia
    CR Lombardia
    CS Calabria
    CT Sicilia
    CZ Calabria
    EN Sicilia
    FC Emilia-Romagna
    FE Emilia-Romagna
    FG Puglia
    FI Toscana
    FM Marche
    FR Lazio
    GE Liguria
    GO Friuli-Venezia Giulia
    GR Toscana
    IM Liguria
    IS Molise
    KR Calabria
    LC Lombardia
    LE Puglia
    LI Toscana
    LO Lombardia
    LT Lazio
    LU Toscana
    MB Lombardia
    MC Marche
    ME Sicilia
    MI Lombardia
    MN Lombardia
    MO Emilia-Romagna
    MS Toscana
    MT Basilicata
    NA Campania
    NO Piemonte
    NU Sardegna
    OG Sardegna
    OR Sardegna
    OT Sardegna
    PA Sicilia
    PC Emilia-Romagna
    PD Veneto
    PE Abruzzo
    PG Umbria
    PI Toscana
    PN Friuli-Venezia Giulia
    PO Toscana
    PR Emilia-Romagna
    PT Toscana
    PU Marche
    PV Lombardia
    PZ Basilicata
    RA Emilia-Romagna
    RC Calabria
    RE Emilia-Romagna
    RG Sicilia
    RI Lazio
    RM Lazio
    0 Emilia-Romagna
    RO Veneto
    SA Campania
    SI Toscana
    SO Lombardia
    SP Liguria
    SP Liguria
    SR Sicilia
    SS Sardegna
    SV Liguria
    TA Puglia
    TE Abruzzo
    TN Trentino-Alto Adige
    TO Piemonte
    TP Sicilia
    TR Umbria
    TS Friuli-Venezia Giulia
    TV Veneto
    UD Friuli-Venezia Giulia
    VA Lombardia
    VB Piemonte
    VC Piemonte
    VE Veneto
    VI Veneto
    VR Veneto
    VS Sardegna
    VT Lazio
    VV Calabria


    I really hope someone can help me with this problem i have and will explain to me like ''for an stupid'' one how to do!!!


    Anticipated thanks,

    Emma V.
    Attached Files Attached Files
    Last edited by Emsky; 01-22-2013 at 07:18 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-04-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    463

    Re: I need an good formula!!! :mad:

    upload a sample file

    Regards
    CA Mahaveer Somani

  3. #3
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: I need an good formula!!! :mad:

    Welcome to the forum.

    To be able to help you, first change your title according to the forum rules.

    ..Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    Then i suggest you to upload a sample workbook.

    ..To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

+ 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