Quote Originally Posted by Bo_Ry View Post
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.