I have a spreadsheet in which there will multiple drop down (combo) boxes. I understand how to build a combo box and refer to the range where the drop down lists lives. But in this series of drop downs, I want subsequent ones to be different depending upon what the selection was in the first drop down.

That is, if the first drop down has options 1, 2, 3 and 4,
I want the second drop down to show a different list ( a different cell range) depending upon the selection in the first drop down.

So it the user selects 1 in the first drop down, I want them to see list A in the second drop down.
If the user selects 2 in the first drop down, I want them to see list B in the second drop down.
And so on.

For what it is worth, there will always be more than two options, so Select Case rather than IF would be required. I confess that I am more accustomed to Access than Excel and am not sure where or how to put any code. In looking through the web, I am not seeing any pages that tell how to do this for a combo box in Excel.

I assume that the condition would be written something like
CASE C1 = 1
Code for the range to use for the drop down
CASE C1 = 2
Code for the range to use for the drop down
Etc.