Drop-Lists and related data

Hopefully, I have correctly understood your request. If so, enterring this formula into both B27, and B29 will solve your problem.

=IF(C16<>"",C16,"")

Let me know if that works.

Thank you so much. The VLOOKUP formula works perfectly!