Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you link 2 drop-down menus?
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=482013 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you link 2 drop-down menus?
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)) -- Regards, Tom Ogilvy "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=482013 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Drop-down menus with subset drop-down menus | Excel Worksheet Functions | |||
How do I link 2 data sets to 2 drop down menus? | Excel Worksheet Functions | |||
Can you link drop down menus | Excel Discussion (Misc queries) | |||
How do you link 2 drop-down menus? | Excel Worksheet Functions | |||
How do I link drop down menus to one another in Excel? | Excel Programming |