Nested lists in excel 2002 - newbie

  • Thread starter Thread starter Specktor
  • Start date Start date
S

Specktor

Hi
I want to set up data validation for user entry.
In first column there is a list of options. In column 2 I want the options
to change depending on what was entered in the first column. In the third
column I want the options in the list to reflect the entry in the second
column.
So....
column 1 options are (for e.g.) PC Hardware, Telephones, Software
IF Column 1 = PC Hardware then options for column 2 list are Mouse,
Keyboard, monitor
If Column 1 = Telephones then options are Handset, Line, hands free kit
etc

If Column 2 = Monitor then options for column 3 are ROLLER, BALL, DESK
etc etc

Any help, thanks in advance
 
You must log in or register to reply here.

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

Selection of drop down list directs auto population of other cell 1
SUM - IF - AND 7
Excel Concatenate with line breaks but ignore blank cells 3
Alphabatize list 3
Multiple-column Drop-down 2
Combining information from two excel list 3
Excel Excel: How do I put a formula in a drop down list 11
Generate a List By a Condition 1

Back
Top