1. upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
2. If you know how to do this without using drop-downs, then you also know how to do it with drop-down. Using a DD is exactly the same as if you typed the values into the cell