Assign values to dropdown menu selections

Here is a reference doc.

I have put the formula in cell B10, but it will eventually be populated down and over so all of the cells are populated.

When "Open" is selected, I want to be able to add in my own value in cell B10. However, when I select a different option in the dropdown menu, I want it to reference back to the cell from the formula.

Hope this helps.