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

Tom Ogilvy

Make a table with the 180 countries in one column and the appropriate number
in the second column. then in the cell were you want the number to appear
put in a formula like

Assume A2 is the dropdown

the formula is in B2

=if(A2="","",vlookup(A2,List!A1:B180,2,false))
 

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

Similar Threads

program drop down menus 1
How do I link drop down menus to one another in Excel? 1
Problem with Pivot Table Drop-Down Menus 4
Use of Drop Down -- A New Beez question 2
linking drop down menu items to corresponding items in other lists 2
How do I set up a form that narrows a data set w/ each menu select 1
Double Drop Down List & Corresponding Text Info Disply 1
Macro for linked drop down boxes 1

Top