Finding unique combinations of adjacent cells in an array with 2 add'l IF criteria

[brashandcrass]

A	B	C	D	E	F	G
First Name	Last Name	Role	Start Up	Contact	Unique + "Invested"	<-- + "Acme Corp"
George	Aquino	Invested	Initech	Justin Abad	George Aquino	???
George	Aquino	Invested	Acme Corporation	Shaun Jai	Femi Folami
Alban	Dushku	Founded	Massive Dynamic	Sean Baako	James Jones
Alban	Dushku	Exited	Massive Dynamic	Karen Brown	Gregor Maier
Femi	Folami	Invested	Soylent Corp	Leonard Chun
Femi	Folami	Invested	Soylent Corp	Shaun Jai
James	Jones	Founded	Initech	Sean Baako
James	Jones	Founded	Initech	Karen Brown
James	Jones	Founded	Initech	Shaun Jai
James	Jones	Founded	Initech	Sean Baako
James	Jones	Invested	Initech 2	Karen Brown
James	Jones	Invested	Initech 2	Karen Brown
Adita	Maier	Acquired	Acme Corporation	Karen Brown
Adita	Maier	Acquired	Acme Corporation	Karen Brown
Gregor	Maier	Invested	Acme Corporation	Karen Brown
Gregor	Maier	Invested	Vehement Capital Partners	Karen Brown
Harold	Sadiq	Founded	Hooli	Leonard Chun
Harold	Sadiq	Founded	Hooli	Justin Abad
George	Shan	Acquired	Acme Corporation	Leonard Chun

<tbody>
</tbody>

In ColF, I'm successfully pulling "unique combinations of adjacent cells" (names in Cols A&B) IF they also "Invested" (ColC) with:

=IFERROR(INDEX($A$2:$A$20&" "&$B$2:$B$20,MATCH(0,IF($C$2:$C$20="Invested",COUNTIF($G$1:G1,$A$2:$A$20&" "&$B$2:$B$20)),0)),"")

I CANNOT figure out how to add an additional IF criteria to return a name that invested (ColC) in Acme Corp (ColD) specifically. Where does this

IF($D$3:$D$20="Acme Corporation"

go?

Thanks!

 

[Peter_SSs]

Try
=IFERROR(INDEX($A$2:$A$20&" "&$B$2:$B$20,MATCH(0,IF($C$2:$C$20="Invested",IF($D$2:$D$20="Acme Corporation",COUNTIF($F$1:F1,$A$2:$A$20&" "&$B$2:$B$20))),0)),"")

 

[brashandcrass]

It worked! Thanks.

Thanks, Peter_SSs

 

[Peter_SSs]

It worked! Thanks.

Thanks, Peter_SSs

Good news!