Excel Dependent Drop-down Lists or hierarchy dropdown lsit

Named range created "MAID_Metadata_List"
=INDEX(INDEX('Document Request No'!$F$2:$AC$112,,MATCH('Document Request No'!$B$5,'Document Request No'!$F$1:$AC$1,0)),1):INDEX(INDEX('Document Request No'!$F$2:$AC$112,,MATCH('Document Request No'!$B$5,'Document Request No'!$F$1:$AC$1,0)),COUNTA(INDEX('Document Request No'!$F$2:$AC$112,,MATCH('Document Request No'!$B$5,'Document Request No'!$F$1:$AC$1,0))))