Using 2 or more dropdown lists to dictate the information returned

Copper Contributor

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.

 

my formula so far is this

=IF(LEN(VLOOKUP($D$2,Reference!A$4:$P$15,3,FALSE))=0, " ",VLOOKUP($D$2,Reference!A$4:$P$15,3,FALSE))

 

$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.

1 Reply