so i made the drop down list and sorted the sheet by that
column.....the problem is that many of the items (rows) need more then
one choice from the list.....so i had to manually enter the additional
list choices for those items as the drop down list only lets you make
one choice

now when i go to sort the rows are sorted only by the first choice and
the second choice is ignored....

is there any way to make a two or three or four column list to use as
the drop down choices....would that help? how do i sort with more then
one choice and still make sure the sort recognizes the additional
choices?

thanks!
rachel