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.

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.