List of 3 Criteria

[Tech56]

Hello,

Is there a formula that can list all names that match 3 criteria? The Value must be at least the number in cell H2.

Thank you

 

[GAURAV BANSAL]

use DGET Function

 

[Tech56]

I have Excel 2010 and not sure what that is.

 

[Juniad]

Try this one in G5 with Ctrl+Shift+Enter and copy it down.
=IFERROR(INDEX($A$2:$A$12,SMALL(IF(($C$2:$C$12=$G$2)*($D$2:$D$12=$H$2)*($E$2:$E$12=$I$2),ROW($E$2:$E$12)-1),ROWS($G$5:G5))),"")

and in H5 with Ctrl+Shift+Enter
=IFERROR(INDEX($D$2:$D$12,SMALL(IF(($C$2:$C$12=$G$2)*($D$2:$D$12=$H$2)*($E$2:$E$12=$I$2),ROW($E$2:$E$12)-1),ROWS($G$5:G5))),"")

 

[Tech56]

Thanks but I am not getting any results for my search. This should include all those with at least the skill value of the search criteria. So if I select 3 it should include 3, 4, and 5 values.

 

[Fluff13]

How about
=IFERROR(INDEX($A$2:$A$12,SMALL(IF(($C$2:$C$12=$G$2)*($D$2:$D$12>=$H$2)*($E$2:$E$12=$I$2),ROW($E$2:$E$12)-1),ROWS($G$5:G5))),"")

 

[Fluff13]

Or if you have the new dynamic arrays
=FILTER(Table18[Name],(Table18[Skills]=G2)*(Table18[Value]>=H2)*(Table18[Certification]=I2))

 

[Tech56]

Perfect thanks Fluff13 I appreciate the help.

 

[Fluff13]

You're welcome & thanks for the feedback