I am trying to come up with a formula in B2 that will either return a set value of text ("COMPLETE") or offer a drop down box with other text options depending on the value selected from a drop down box in A2.

A2 has a named range called "Results" that has several possible coded values for results (LVM, REF, REN, NA, EOO, RC). If the user selects REF, REN, or EOO on the A2 drop down box, then B2 needs to be marked "COMPLETE". If they select any other value code, then B2 needs to display the same drop down options as A2.

Thanks in advance for any assistance!