Index, Match, Min, If, And in one Array formula

Hi guys,

$B$6:$B$22 contains names
$J$6:$J$22 contains numbers
$I$6:$I$22 contains Yes or No value

Please Login or Register  to view this content.

I'm trying to use the above formula to return a name value from COLUMN B, but only if COLUMN I contains "Yes" and COLUMN J > 0, so in below value I'd like to return Test Name2, any ideas?

COLUMN B COLUMN I COLUMN J

Test Name1 Yes 0
Test Name2 Yes 5

something like this...

Please Login or Register  to view this content.

- array formula , ctrl+shift+enter