May 14 2021 11:12 AM
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.
May 14 2021 11:38 AM