I am trying to create a number of dependednt drop lists in excel. 3 maybe 4. What i need is for each to be dependent on the previous with a description of the product to be shown in a chosen cell after relevant selections have been made. For example if list one is modes of transport ( eg car boat etc) and car was selected the second list should show makes ( eg ford) and the third list model. After that maybe price or desription based on info somewhere else in the workbook should be shown.
