This is my VERY first post, so apologies if I'm not doing this entirely correctly.

I have a sheet with a dependent drop down. The main drop down is in F7:F31 (list includes IGB, MUNICIPAL, NONE, HY) and the dependent drop down is G7:G31 (list varies based on column F).

My problem is that when I choose something from the drop down in column F, the LIST in column G updates properly, but if I change column F once more, the CELL VALUE in column G sticks (once again the drop down list updates properly, but the value in the cell itself still reflects the prior selection in column F).

My understanding is that this can't be fixed other than in VBA, but I'm not sure how to go about doing that. Can someone help please? I'm also amenable to forcing each primary drop down to have a default value in column F. Either way works, as long as the value in column G doesn't continue referencing prior changes in column F.

Thanks in advance.