Excel drop down list populated based on number in cell

I'm trying to create a drop down list based on a number that can change in a cell. The max the drop down list would display is 14 numbers. When the cell value changes I want the drop down list to change to the new value.

If cell value is over 14 then only display 1 - 14 in drop down list
If cell value is under 14 then display 1 - cell value in drop down list

Column D is what I'm referencing to populate drop down. My issue is if it gets to 0 then the drop down list no longer works. I would like it to display 0.

Column C will change(user will change) and Column D will list remainder number up to 14

I'm referencing I4 to populate drop down in this example.

I have a formula that seems to work in O7 but when I populate in drop down list it produces an error.

Thank you this works great