LINKING CELLS

[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

 

[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.

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

BERLIN AND WHEN I WOULD SELECT FRANCE THAT CELL A1 WOULD THEN READ PARIS AND
SO ON, COULD ANYONE TELL ME IS THIS POSSIBLE

 

[Frank Kabel]

Hi
have a look at
http://www.contextures.com/excelfiles.html#DataVal
and get the Excel workbook:
http://www.contextures.com/DataValNameID.xls

this gives you an example of a 'two column' listboxes

 

[Guest]

Sorry about the CAPS, Thanks for the help

I'll go now and try to figure it all out

----- Frank Kabel wrote: ----

H
have a look a
http://www.contextures.com/excelfiles.html#DataVa
and get the Excel workbook
http://www.contextures.com/DataValNameID.xl

this gives you an example of a 'two column' listboxe


-
Regard
Frank Kabe
Frankfurt, German

jinx wrote