How do i create dependant drop down lists. I have looked at using the Inderict() but i can not understand how to get it to work for me. I have a list of 46 catagories on one sheet with a key next to them. on another sheet i have all the sub catagories listed in two colums; one column listing a key to the main catagory with 5 descriptions listed in the second column for each catagory. From what I have tried the indirect does not work as it looks at subcatagories that are indiviual columns.