linking drop down menu items to corresponding items in other lists

[Jklay]

My original task was to take two columns with 6 items in each an
collapse them - where the first item of the first column somehow link
to the first item of the second column and so on.
(e.g. if item "1" from first column is chosen item "1" from secon
column appears in 2nd column)

I thought I could use a drop down menu for the first column and the
somehow have the corresponding item appear in the second column whe
the user selects an option from the first column drop down menu.

I've created the first column drop down menu (using the Data Validatio
method) but have no idea how to complete the second step: having th
corresponding item appear in the 2nd column when a choice is selecte
in the first column. I thought of perhaps using IF statments but a
not sure if they work with drop down menus.

Any suggestions?

Thanks, Jennife

 

[Frank Kabel]

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))

 

[hglamy]

Thank you very much Frank Kabel, great work !

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))