I have lots of DVDs which I want to catalogue them using Excel 2010. I have 3 sheets. In Sheet 3, there are 2 lists: Category (PG, M18, General, Adult) and Language (English, Korean, Japanese, etc). Sheet 2 contains data such as Titles, Category, Language, etc. I use Sheet 1 to create a drop down list for selecting a Title and then displaying information of the selected DVD. (I use vlookup formula and it works fine.)
Then I created another drop down list for Category. I want to be able to select a category, such as M18, and then a list of DVD titles that fall under this category will be displayed. However I failed to get the display as there are something wrong with the formula I used.
I have attached the file so that it will be clearer to see my problem. In the file, you will see that I have tried 2 different formulae but they didn't work.
I hope someone will assist me in getting the formula correct. Thank you.
Then I created another drop down list for Category. I want to be able to select a category, such as M18, and then a list of DVD titles that fall under this category will be displayed. However I failed to get the display as there are something wrong with the formula I used.
I have attached the file so that it will be clearer to see my problem. In the file, you will see that I have tried 2 different formulae but they didn't work.
I hope someone will assist me in getting the formula correct. Thank you.