If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
linking drop down menu items to corresponding items in other lists
My original task was to take two columns with 6 items in each and
collapse them - where the first item of the first column somehow links to the first item of the second column and so on. (e.g. if item "1" from first column is chosen item "1" from second column appears in 2nd column) I thought I could use a drop down menu for the first column and then somehow have the corresponding item appear in the second column when the user selects an option from the first column drop down menu. I've created the first column drop down menu (using the Data Validation method) but have no idea how to complete the second step: having the corresponding item appear in the 2nd column when a choice is selected in the first column. I thought of perhaps using IF statments but am not sure if they work with drop down menus. Any suggestions? Thanks, Jennifer --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
linking drop down menu items to corresponding items in other lists
Hi
use VLOOKUP for this. e.g. your data is on sheet 1, column A+B and your drop down is on sheet 2, cell A1. Enter the following in B1 =IF(A1="","",VLOOKUP(A1,'sheet1'!A1:B100,2,0)) -- Regards Frank Kabel Frankfurt, Germany My original task was to take two columns with 6 items in each and collapse them - where the first item of the first column somehow links to the first item of the second column and so on. (e.g. if item "1" from first column is chosen item "1" from second column appears in 2nd column) I thought I could use a drop down menu for the first column and then somehow have the corresponding item appear in the second column when the user selects an option from the first column drop down menu. I've created the first column drop down menu (using the Data Validation method) but have no idea how to complete the second step: having the corresponding item appear in the 2nd column when a choice is selected in the first column. I thought of perhaps using IF statments but am not sure if they work with drop down menus. Any suggestions? Thanks, Jennifer --- Message posted from http://www.ExcelForum.com/ |
#3
|
|||
|
|||
linking drop down menu items to corresponding items in other lists
Thank you very much Frank Kabel, great work !
"Frank Kabel" schrieb im Newsbeitrag ... Hi use VLOOKUP for this. e.g. your data is on sheet 1, column A+B and your drop down is on sheet 2, cell A1. Enter the following in B1 =IF(A1="","",VLOOKUP(A1,'sheet1'!A1:B100,2,0)) -- Regards Frank Kabel Frankfurt, Germany My original task was to take two columns with 6 items in each and collapse them - where the first item of the first column somehow links to the first item of the second column and so on. (e.g. if item "1" from first column is chosen item "1" from second column appears in 2nd column) I thought I could use a drop down menu for the first column and then somehow have the corresponding item appear in the second column when the user selects an option from the first column drop down menu. I've created the first column drop down menu (using the Data Validation method) but have no idea how to complete the second step: having the corresponding item appear in the 2nd column when a choice is selected in the first column. I thought of perhaps using IF statments but am not sure if they work with drop down menus. Any suggestions? Thanks, Jennifer --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|