I'm struggling to complete this second dependent dropdown which is pulling information from the first dropdown that consists of both multiple words and illegal characters, such as, "&". my first dropdown is in cell A2. How would you go about this? Thanks in advanced!