Excel Dependent Drop-down Lists or hierarchy dropdown lsit

Do you know how to do hierarchy/dependent drop down list in Excel.

Basically in the Document Request No Tab if someone chooses the MAID Discipline from a dropdown based Column J. The MAID Metadata (Defined List Column K - AC) will provide a refined drop down list based upon MAID Metadata list and not to scroll down the whole list.

I have tried to use the =INDIRECT in the Source box of Validation but the dropdown didnt seem to work

Can someone please help or tell me what I am doing wrong