Okay, this isn't very elegant, but it worked.

I did four columns...A-D...don't ask why I skipped C :)
A B C D
Colors Things 3
Purple =IF($D$1=3,"Grass","") 1
Blue =IF($D$1=3,"Eggs","")
Green =IF($D$1=2,"Sky","")
=IF($D$1=2,"Moon","")
=IF($D$1=1,"Rain","")
=IF($D$1=1,"People","")

I created a combo box on the data in A. The resut is in D1. Depending
on the value of D1, certain items will appear in column B.

I then created a combo box for column B with the value in D2.

Problem - You get a lot of blank spaces in the second combo box.
Workaround for that problem? I created a macro to sort Column B in
descending order. I set the First Combo box to run that macro every
time the combo box changes. I then changed the Second Comob box to use
on B2:B3. It works...but you will want to merge D1 and D2 together to
get a "for sure" value of what the final result is.

Not elegant...but it will get the job done.


--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611
View this thread: http://www.excelforum.com/showthread...hreadid=484165