How do I create a multi-row list box in Excel 2010

I have 2 columns of values in excel, lets call them Selection1 and Selection2.

I want to provide users with a drop-down that allows them to select either 'Selection2' or 'Selection2'.

Based on their selection, a series of cells would be updated with the values associated with either 'Selection1' or 'Selection2'.

Appreciate any help.
streetwise99Asked:
Who is Participating?
 
Kannan KManager - EngineeringCommented:
Hi,

you can use the formula like, =IF($H$4=$D$4,D5,IF($H$4=$E$4,E5,"None"))

Please refer the sample workbook.

KK,
Multirow.xlsx
0
 
Kannan KManager - EngineeringCommented:
Hi,

You can click Data ==> Data validation option. in the dialog box you select List option and say from where it has to pick. Please find the image for your reference.

KK,
ExcelDataValidation.png
ExcelDataValidationOutput.png
0
 
Arno KosterCommented:
instead of relating them to cell contents, you can also type the values in the data validation box :

option1 ; option 2

the user will then have to choose between option 1 and option 2

0
 
SafetyFishCommented:
Can you post an example workbook showing which cells you want updated based on the drop down list?
0
 
streetwise99Author Commented:
Refer to the attached screen-shots.

I have 2 columns, titled 'Selection1' and 'Selection2'. Each of these have a series of data-rows associated with them.

I want to create a drop-down that allows users to choose either 'Selection1' or 'Selection2'. Based on their selection the associated data cells below will update.

User has selected 'Selection1' from drop-down
 User has selected 'Selection2' from drop-down
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.