Index <0, return Min of Match

[loudnoiseman]

Hi Everyone,

I want to Index only values less than zero in column B, and need to return the Minimum corresponding Matched value in column A.

So in the below data, the correct result would be 3.

Thanks so much!

Column A	Column B
13	-2
17	-8
8	-3
3	-4
2	5
3	10

 

[Fluff]

How about

=minifs(a:a,b:b,"<0")

 

[loudnoiseman]

That absolutely works!

Thank you Fluff!!

 

[Fluff]

You're welcome & thanks for the feedback.