This is the follow up post from my previous post – How to create a dependent dropdown list in #Excel. As mentioned, it could be easier to illustrate the concept using a video, especially for the use of Dynamic Arrays.
Here comes the videos, in both English and Cantonese. Hope you like it. 😉