Columns Drop Down Options

[Nishkar]

Scenario is as follows:

I have 2 columns of which a data validation command is applied so that each
column only displays the selected drop down opions which the user may choose,
however, i need now to do the following:

If in column 1, an option is selected, column 2 must only present the sub
category options that apply to the option selected in column 1 & not all
options.

Any idea of this is possible in MS Excel 2003, if so, how would you do this?

 

[Pete_UK]

Debra Dalgleish shows how to do it here:

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

Hope this helps.

Pete

 

[Suleman Peerzade]

For eg.

You have a table in col
S T
excellent 10
good 7.5
Satisfactory 5
Below Arvg 2.5
NA 0

This would be a column where in you can specify what should come after the
end user selects from the validated drop down list. We are using Vlookup over
here
so the formula is

=VLOOKUP(K31,S2:T6,2,"False")
This would give you exact figures/results