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/

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/

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/