Creating a dropdown list in Excel is pretty straight forward. You pick the cell and then you choose what you want the choices to be.
However, what if you are making two dropdown lists, where the second one will have choices that depends on what the first dropdown result is?
I will show you how to easily get past this.
Let;s use this example:
In cell A2 we have a dropdown with a list of 3 car types: Ford, Chevy and Nissan.
We want the choices in the dropdown in B2 to be models of that brand. We have a list of those models in columns F,G and H.
So in A2 we set up the basic dropdown list to give the user the choice of Ford, Chevy or Nissan.
Then in B2, we have to create a Nested IF statement within the Data Validation. To do this, go to cell B2. Then go to Data at the top and down to Data Validation.
In the Allow box, drop down to list. Then in the Source section, this is where we would normally enter our range of cells for choices, like putting F1:F4.
However, since this is dependent on the results in A2, we need to put an IF statement in there. We would use:
What this is doing is checking cell A2 first. If it is Ford, then it will use F1 to F4 as the choices. If it is not Ford, then it checks if A2 equals Chevy. If it does, then it uses G1 to G4 as choices.
And if it is neither of them, the last part of the IF statement just says to use H1 to H4.
So our final output should work like this: