How do you link 2 drop-down menus?

J

jd1655

Hello,

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

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

*Second column’s cells have DD menu with a list of numbers (only tw
numbers: 1&2). *Certain NUMBERS in column two go with certai
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, an
then choose the corresponding NUMBER that goes this that country i
column two. (note: There two separate columns must remain)

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


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

Best regards,
Jef
 
J

John Michl

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
 
J

jd1655

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
 
J

John Michl

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top