LINKING CELLS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top