Excel Validation / Dropdown list Problem

  • Thread starter Thread starter edsulya
  • Start date Start date
E

edsulya

I am trying to write a purchase order for my company in MS-Excel 2002.
I am currently using a validation / dropdown list to pick th
description of the product I want from a list of 100 choices.

I would like to break the list of 100 items into five categories of 2
items each to make selection easier.

One column would list five categories in a drop down menu.

The next column would allow me to choose from the twenty products unde
that category.

I am not sure of the formula or code to accomplish this task.

Please advise.

Ed Suly
 
Edsulya,

Suppose your dropdownboxes are in A1(1 to 5) and in A2 (20 values)

Name the ranges of 20 values : I assume in this example List1, List2,
....,List5

In A1 Data/Validation / List / 1,2,3,4,5

In A2 Data / Validation/List/ =Choose(A1,List1,List2,List3,List4,List5)

NB When a choice is made in cell A2 and thereafter cell A1 is changed, there
will be no errrormessage that a wrong list is used in cell A2.
(This is always the case with DATA / Validation)


--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top