creating dependent list boxes

T

twlove

I have a table containing product part numbers. Each of these part
numbers is available with up to three (3) separate accessories. Some
products are available with all three accessories while others may only
be available with two of the three or even one of the three
accessories.

What I want to do is this: When the user selects a particular part
number in a drop down list in lets say cell A1, I want cell A2 to
display a drop down list containing only those accessories available
for the selected part number.

Example: Cell A1 = Part #123
Cell A2 = drop down displays accessories A, B & C

Cell A1 = Part #555
Cell A2 = drop down list displays accessory A only

Any help with this would be greatly appreciated!
 
D

Debra Dalgleish

I assumed you had a product table, with products listed in column A,
Accessories listed in row 1, and marked with an "X" where an accessory
is available for a product. Based on the table, the correct list of
accessories can be shown, after a product is selected in the order form.

The sample file is here:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Dependent Cell List Lookup'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to dynamically change the list in drop down list based on thevalue of another cell? 1
Conditional Validation In Excel 1
Pick from drop-down list gives empty or erroneous result 6
AutoComplete Entry in Text Box or Drop Down List 6
Help with creating drop down 1
Controlling Entire Worksheet with VBA Function 6
Choosing a drop-down menu selection returns value to another cell 2
Drop-down list and error message 1

Top