Array: Min and Lookup

[leviathan86]

I browsed through the forums and found a way to look up a specific cell from a data table using an array.

=MIN(IF(Model!$E$6:$E$321=Summary!B13,Model!$G$6:$G$321," "))

Summary!B13 Is the lookup value
Model!$E$6:$E$321: Data table that contains the look up value
Model!$G$6:$G$321: Value that will be put in that matches the lookup value.

The change I would like to make is a constraint the output value will be the min that is greater than zero.

[NBVC]

Try:

=MIN(IF(Model!$E$6:$E$321=Summary!B13,IF(Model!$G$6:$G$321>0,Model!$G$6:$G$321)))

[leviathan86]

You are the best. Closed