Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: Dependent drop down lists peteryac60 Yes that is what I meant! Worked my way round it now though I think. Lesleyanne Re: Dependent drop down lists peteryac60 Yeas I am fairly competent with that basic operation. Having created that I would like to have the adjacent cell display a list of comments relating to that selected on its left. have tried =index and =indirect Dependent drop down lists I would like to create a drop down list with multiple words