Using the following table, I am trying to write a formula (in Excel 2010) which will identify the minimum value given two constraints (e.g., identify the minimum efficacy for all Non-compliant 34-Watt light bulbs):

Wattage Compliant (C) or Non-compliant (NC) Efficacy
34 C 90.2
34 C 91.5
34 NC 85.3
34 NC 86.9
40 C 89.1
40 C 90.6
40 NC 79.7
40 NC 80.8
32 C 100.8
32 NC 87.5
25 C 101.3
25 C 98.9

I have worked out a MINIF function which can return the minimum efficacy value of based on one variable (wattage or compliance) but cannot figure out how to accommodate the second variable.

I have tried several times to nest the AND function into an IF function nested in the MIN function without success. Maybe I am approaching it from the wrong angle?

FYI, I will need to identify the MAX and MIN Efficacy values for compliant (C) and non-compliant (NC) of each wattage variation within a similar, but much longer list in a second table like this:

Description Min Max
34W NC
40W C
40W C
32W C

Thanks in advance for any help you can offer!