trying to find away to get solution for one result depending on many drop down lists

%3CLINGO-SUB%20id%3D%22lingo-sub-1593074%22%20slang%3D%22en-US%22%3Etrying%20to%20find%20away%20to%20get%20solution%20for%20one%20result%20depending%20on%20many%20drop%20down%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1593074%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20was%20trying%20for%20few%20days%20to%20get%20an%20answer%20of%20this%20issue%20but%20i%20couldn't%2C%20i%20hope%20someone%20help%20me%20with%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20basic%20explain%20for%20the%20issue%20is%20that%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%2010%20employees%20and%20there%20is%20a%20table%20for%20their%20information%20like%3A(%20year%20of%20hire%2C%20Performance%2C%20Grade%20and%20job%20title)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20those%2010%20employees%20are%20in%20common%20to%20each%20other%20by%20either%20the%20Year%2C%20Performance%2C%20Grade%20or%20Job%20title.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20i%20make%20drop%20down%20list%20for%20%3A%20(Year%2C%20Performance%2C%20Grade%20or%20Job%20title)%2C%20to%20search%20and%20find%20the%20employee%20faster%20and%20easier%20by%20choosing%20from%20drop%20down%20lists%2Ceither%20one%20list%20or%20two%20or%20all%20of%20them%2C%20so%20if%20i%20choose%20year%202010%20from%20the%20Year%20drop%20down%20list%2C%20the%20result%20is%20those%20Employees%20are%20common%20of%20Year%202010%20either%20one%20employee%20or%20many%2C%20and%20if%20i%20choose%20Year%20and%20Grade%2C%20i%20get%20result%20to%20Employees%20of%20year%20and%20grade%20and%20etc....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20hope%20i%20explain%20it%20good%20and%20understandable.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1593074%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1593435%22%20slang%3D%22en-US%22%3ERe%3A%20trying%20to%20find%20away%20to%20get%20solution%20for%20one%20result%20depending%20on%20many%20drop%20down%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1593435%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F761910%22%20target%3D%22_blank%22%3E%40iBeoZD%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20formula%20will%20work%20if%20you%20have%20the%20most%20recent%20version%20of%20Excel%3B%20it%20makes%20use%20of%20the%20FILTER%20function%20to%20evaluate%20all%20the%20criteria%20and%20return%20the%20row%20or%20rows%20of%20any%20employees%20who%20meet%20all%20four.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DFILTER(A2%3AA11%2C(B2%3AB11%3DJ3)*(C2%3AC11%3DK3)*(D2%3AD11%3DL3)*(E2%3AE11%3DM3)%2C%22None%20found%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20the%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1596171%22%20slang%3D%22en-US%22%3ERe%3A%20trying%20to%20find%20away%20to%20get%20solution%20for%20one%20result%20depending%20on%20many%20drop%20down%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1596171%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3BThank%20you%20very%20much%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, 

 

i was trying for few days to get an answer of this issue but i couldn't, i hope someone help me with this.

 

the basic explain for the issue is that:

 

Example:

 

i have 10 employees and there is a table for their information like:( year of hire, Performance, Grade and job title) 

 

and those 10 employees are in common to each other by either the Year, Performance, Grade or Job title.

 

so i make drop down list for : (Year, Performance, Grade or Job title), to search and find the employee faster and easier by choosing from drop down lists,either one list or two or all of them, so if i choose year 2010 from the Year drop down list, the result is those Employees are common of Year 2010 either one employee or many, and if i choose Year and Grade, i get result to Employees of year and grade and etc....

 

i hope i explain it good and understandable.

2 Replies

@iBeoZD 

 

This formula will work if you have the most recent version of Excel; it makes use of the FILTER function to evaluate all the criteria and return the row or rows of any employees who meet all four.

 

=FILTER(A2:A11,(B2:B11=J3)*(C2:C11=K3)*(D2:D11=L3)*(E2:E11=M3),"None found")

 

See the attached.