Re: Dropdown dependency (difficult with INDIRECT)

mathetes 

Thanks a lot for putting the time in to provide help 🙂 Really appreciate it!

My problem is really that the roles in the raw data has to come from a named range as, there are potentially 10-2 roles and I don't want people to add entries based on free text but much more pick from a list of allowed roles for each line.