If I interpreted correctly, you are trying to:
* find stores those have sales >2 AND STR<45
* within these stores, find which store has minimum stock
for instance, there are 3 stores, in which only 2 stores have sale >2 AND STR<45, then find minimum stock among them.
Try :
=LOOKUP(2,1/(IF($G$4:$K$4="STR",$G$5:$K$5,"")=MIN(IF(IF($F$4:$J$4="SALE",$F$5:$J$5,0)>2,IF(IF($G$4:$K$4="STR",$G$5:$K$5,46)<45,IF($G$4:$K$4="STR",$G$5:$K$5,""),""),""))),$F$3:$J$3)
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Bookmarks