I am in the process of creating a maintenance checklist using Excel. I am planning on using up to 4 drop down lists to dictate what information is returned. I want the ability to have these drop down lists to filter and only return information based on the choices picked in these drop downs.
$D$2 is my first drop down list. I want to add up to 4 total to return the information I want shown. I am having trouble with the next drop down list in this formula. All of the drop down lists are on the same sheet.