Hello,

I'm in a lurch... I need to link to side-by-side drop down menus. It
goes like this:

*First column’s cells have DD menu with a list of about 180 countries

*Second column’s cells have DD menu with a list of numbers (only two
numbers: 1&2). *Certain NUMBERS in column two go with certain
COUNTIRIES from the first column (USA gets 1, France 2, Mexico 1,
Germany 2 etc...)
*As it stands, the user must first choose the COUNTRY in column 1, and
then choose the corresponding NUMBER that goes this that country in
column two. (note: There two separate columns must remain)

***I want to make it so that when the COUNTRY is selected in column
one, the corresponding NUMBER automatically appears in column 2 *


Can anyone help? I've got a deadline fast approaching!!

Best regards,
Jeff


--
jd1655
------------------------------------------------------------------------
jd1655's Profile: http://www.excelforum.com/member.php...o&userid=28540
View this thread: http://www.excelforum.com/showthread...hreadid=482012

Create a separate table of countries and corresponding numbers. Sort
it by country.

Instead of a second drop down list, us a vlookup formula to find the
number based on what country was selected in the the first drop down.

- John

Thanks John. Sadly I am not so advanced with Excel. Could you fill me in
on what a Vlookup is and how I would do this??

Jeff


--
jd1655
------------------------------------------------------------------------
jd1655's Profile: http://www.excelforum.com/member.php...o&userid=28540
View this thread: http://www.excelforum.com/showthread...hreadid=482012

See http://www.xldynamic.com/source/xld.Dropdowns.html for a technique that
does this

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jd1655" wrote in
message ...

Hello,

I'm in a lurch... I need to link to side-by-side drop down menus. It
goes like this:

*First column's cells have DD menu with a list of about 180 countries

*Second column's cells have DD menu with a list of numbers (only two
numbers: 1&2). *Certain NUMBERS in column two go with certain
COUNTIRIES from the first column (USA gets 1, France 2, Mexico 1,
Germany 2 etc...)
*As it stands, the user must first choose the COUNTRY in column 1, and
then choose the corresponding NUMBER that goes this that country in
column two. (note: There two separate columns must remain)

***I want to make it so that when the COUNTRY is selected in column
one, the corresponding NUMBER automatically appears in column 2 *


Can anyone help? I've got a deadline fast approaching!!

Best regards,
Jeff


--
jd1655
------------------------------------------------------------------------
jd1655's Profile:
http://www.excelforum.com/member.php...o&userid=28540
View this thread: http://www.excelforum.com/showthread...hreadid=482012

Apologies if this is a duplicate post. Not sure if the first one went
through.

Here's a simple example.
In column G starting row1 enter
[Select One]
France
Germany
Mexico
USA

In column G starting row 1 enter
N/A
2
2
1
1

In cell A1, create a data validation drop down. From the menu, Data
Validation List and then type in or select range G1:G5 as the
validation list. Select OK to finish this out. In cell one, choose
"[Select One]" from the drop down.

In cell B1, enter =VLOOKUP(A1,$G$1:$H$5,2,False). Which means, find
the value in cell A1 by searching vertically in the first column of
range G1:H5. When found, pull the corresponding value in the second
column. False means it must find an exact match.

Hope that helps.

- John Michl
www.JohnMichl.com