Extract data from list but not exact match on text-CodePudding

I am trying to extract / filter a list of names based on if a player is attending. For example if Player A is FALSE not playing only show the last 3 pairs in the example below.

I have a list of names of players. Column A (Players) Column B (Attending T / F) I then have a list of pairs for example. Column D (Pairs not played)

I have tried a few different ways but cannot see a way round it. This is a sample data set. My actual data set has 20 Individual names and 40 pairs. At the end I'd like a list in F of possible pairs of players attending

I thought about using IF, IFERROR, VLOOKUP, INDEX and MATCH.

Any ideas?

CodePudding user response：

So, this works, but not sure if I can find a simpler method:

Note the first formula in cell B6 has changed:

IF(AND(C1=TRUE,C2=TRUE),B1&" "&B2,"")

The others are correct and the two missing are just B6 dragged down.

CodePudding user response：

With the following Excel tables:

[Table1 and Table2 image] (https://i.stack.imgur.com/qNsBE.jpg)

Table2[Assignable] formula:

=INDEX(Table2,MATCH([@Player1],Table2[Player],0),2)*INDEX(Table2,MATCH([@Player2],Table2[Player],0),2)

1 indicates both players present, 0 means one or both are absent.