Hi all,

I am trying to create a worksheet in excel that allows the user to choose a certain type of fork lift truck using dependent lists. The four lists are (in desending order): type, capacity, brand, & model. I have been working on creating the dependent lists for a while, but the complexity of what I'm trying to achieve is creating some issues. All the tutorials I am finding online assume your lists are mutally exclusive. Aka, no option is repeated. But in my case, many options are repeated.

For example, the following are all options I would like a user to have:

4 wheel sit down > 4,000 lbs > Raymond > M75

3 wheel sit down > 3,000 lbs > Caterpillar > E300

Reach Truck > 4,000 lbs > Raymond > M80

I can't figure out how to do something like this since both "Raymond" and "4,000 lbs" appear more than once in the list (and my actual list includes dozens of repeating items). Can anyone help me out?