"Desired Effect is to switch between a simple reference, and a Dropdown list that matches one of the Option.X columns based on previously chosen list items dropdown1 and dropdown2" (from the file)
Based on the selections shown in the file attached to post #6, what should the drop down for cell A18 display? I am guessing Option.A, Option.B, Option.C and OptSelect because DropDown2 displays Type_A