I have already created a Excel Drop-down list tutorials without VBA with the help of indirect formula I am sure that can help you.
basically I have created 2 tutorials one is for basic and the 2nd one is for advanced.
Search on YouTube "How to create dependent drop down list in excel with multiple selections jktipstricsk"
This is the basic tutorial, I hope its useful for you, if you need advanced tutorial you can have it in the end of this tutorial video.
Looking forward to hearing from you,
