Im trying to have a the excel sheet pull in a list depending on what is selected in another list. The idea is to have a dropdown in D1 of two list depending on that value the information updates in D5 (roles).. Driving me nuts hope someone can understand what im trying to do and help. Fingers...