How do I use something similar like LOOKUP on a piece of a sentence and pull the correlating values?

For my trading dashboard I want to get insight of the win rate of different trading confluences and grouped confluences, but I'm already stuck in calculating the individual confluences.

Using COUNTIF(Confluence;"*Daily*") I manage to count each confluence. And I used LOOKUP when there was only 1 string of value in the confluence column.

How do I get a similar result like LOOKUP for "Daily", "Monthly" etc? So I can pull the value in the win/loss column from table one (Trade log) to my second table (Individual confluence results)?

And is there a way to automatically generate all possible confluence pairs in a third table?