I have a table of cells filled with either Y or N. I want the contents of the Y/N table to determine which columns are included in a subsequent content matching check. The desired rule would produce the following behaviors:
If A1, B1, and C1 all contain Y, I want $E5 to display whether the contents of $A5, $B5, and $C5 all match.
If A2 and B2 contain Y but C2 contains N, I want $F5 to display whether the contents of $A5 and $B5 match.
If A3 and C3 contain Y but B3 contains N, I want $G5 to display whether the contents of $A5 and $C5 match.DESIRED OUTPUTS

It’s fine if there is an intermediary table that needs to be constructed, as long as it can all react automatically to changes to the Y/N and A/B table contents. I considered writing a unique rule for each column, but that would be completely impractical given how often the Y/N table will change.

If there’s a simpler method that can achieve the sample results than the method I’m describing, that’s welcome, too.