LINKING CELLS

J

jinx

HI ALL

WAS WONDERING IF ANYONE COULD HELP WITH THIS

MY PROBLEM IS I HAVE A DROP DOWN LIST WITH ALL DIFFERENT COUNTRIES IN I
WHAT I AM TRYING TO DO IS WHEN I SELECT GERMANY THAT CELL A1 WOULD READ BERLIN AND WHEN I WOULD SELECT FRANCE THAT CELL A1 WOULD THEN READ PARIS AND SO ON, COULD ANYONE TELL ME IS THIS POSSIBLE
 
A

Andy B

jinx

Please switch off your CAPS! It is considered bad etiquette.

You could set up a table with one column containing countries and one
containing their capitals. You can then use a simple VLOOKUP() function to
return the relevant capital:

Germany Berlin
France Paris
England London

=VLOOKUP(A1,A2:B4,2,FALSE) where your drop-down is cell A1 and your list
is A2:B4

Andy.

jinx said:
HI ALL,

WAS WONDERING IF ANYONE COULD HELP WITH THIS,

MY PROBLEM IS I HAVE A DROP DOWN LIST WITH ALL DIFFERENT COUNTRIES IN IT
WHAT I AM TRYING TO DO IS WHEN I SELECT GERMANY THAT CELL A1 WOULD READ
Click to expand...
BERLIN AND WHEN I WOULD SELECT FRANCE THAT CELL A1 WOULD THEN READ PARIS AND
SO ON, COULD ANYONE TELL ME IS THIS POSSIBLE
 
Top