I am currently editing a workbook that will be used by multiple people. I want to limit user error so I need to create some rules within the drop downs that limit the number of choices depending on how they select the first two columns. For Instance, my first column has 5 choices. My second column will have anywhere from 1 to 4 choices, depending on first columns choice. My third column will be dependent on the first two choices. It could have 8 choices available in column 3 or just one choice. Further, if columns 1,2,3 have a particular set of values in them, then columns 4-6 are limited to one choice as well. Is there any way to do this? I feel like some of the formulas I know for Indirect and Substitute may work but I feel I will have to spend a lot of time to build out many name lists for this to work properly.