Dependent Drop-down with Dynamic Named Ranges

Hi.

I am attaching a sample spreadsheet with code that I used from Contextures.com (https://www.contextures.com/xldataval11.html).

I added my named ranges, data validation, and combo boxes.

On my named ranges, I purposely only made one of them a dynamic range using INDEX, ROWS, and COUNTBLANK. This is the only range that does not show up in the combo box drop-down.

I need to know what I need to change in the code for the sheet or in the named range to make it show up. I do not want all of the blank rows at the end of the list to appear in the combo box.

Any help is appreciated.

I can't answer your question but maybe you're interested in a different method to set up dependent data validation.
This method will make it easier to maintain the data set because you only need 1 table.

Here's 2 examples:

Thank you Akuini . I will check this out. I appreciate your help.

Originally Posted by Bo_Ry

Change range name typelist to

=OFFSET(Lists!$B$4,1,MATCH(A2&"s",Lists!$C$4:$I$4,),COUNTIF(INDEX(Lists!$C$5:$I$105,,MATCH(A2&"s",Lists!$C$4:$I$4,)),"*?"))

Thank you.

I downloaded the revised spreadsheet and it works, of course. When I try to make my original upload look the same, it does not work.

How do you get the list to show up in Entry!D2? And is it necessary for it to show up, or is that just for my benefit?

If it is necessary, my actual spreadsheet would have to have it somewhere else, hidden. Is that ok?

I am using this same Data Validation in several places on the same sheet, would I have to have a hidden list for each of them?

Sorry for all the questions. This stuff is a little out of my depth.