Using 2 or more dropdown lists to dictate the information returned

%3CLINGO-SUB%20id%3D%22lingo-sub-2355831%22%20slang%3D%22en-US%22%3EUsing%202%20or%20more%20dropdown%20lists%20to%20dictate%20the%20information%20returned%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2355831%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20in%20the%20process%20of%20creating%20a%20maintenance%20checklist%20using%20Excel.%20I%20am%20planning%20on%20using%20up%20to%204%20drop%20down%20lists%20to%20dictate%20what%20information%20is%20returned.%20I%20want%20the%20ability%20to%20have%20these%20drop%20down%20lists%20to%20filter%20and%20only%20return%20information%20based%20on%20the%20choices%20picked%20in%20these%20drop%20downs.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emy%20formula%20so%20far%20is%20this%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E%3DIF(LEN(VLOOKUP(%24D%242%2CReference!A%244%3A%24P%2415%2C3%2CFALSE))%3D0%2C%20%22%20%22%2CVLOOKUP(%24D%242%2CReference!A%244%3A%24P%2415%2C3%2CFALSE))%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%24D%242%20is%20my%20first%20drop%20down%20list.%20I%20want%20to%20add%20up%20to%204%20total%20to%20return%20the%20information%20I%20want%20shown.%20I%20am%20having%20trouble%20with%20the%20next%20drop%20down%20list%20in%20this%20formula.%20All%20of%20the%20drop%20down%20lists%20are%20on%20the%20same%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2355831%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2355928%22%20slang%3D%22en-US%22%3ERe%3A%20Using%202%20or%20more%20dropdown%20lists%20to%20dictate%20the%20information%20returned%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2355928%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1054161%22%20target%3D%22_blank%22%3E%40DougHayes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20%3CA%20href%3D%22https%3A%2F%2Fcontexturesblog.com%2Farchives%2F2018%2F06%2F28%2Fmultiple-dependent-drop-downs%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EMultiple%20Dependent%20Drop%20Downs%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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