Match pair of cells with another pair of cells

Question

I was trying to return a TRUE or FALSE value (to be used for conditional highlighting) to see if a pair of cells match another pair of cells (important that it's a pair or, more accurately, on the same row). For instance, what formula would be appropriate for the following desired output to be reflected.

Note that here we are checking if Column 3 and 4 values together appear in column 1 and 2 together.

Answer 1

Based on your data this should work:

=NOT(ISERROR(FIND(TEXTJOIN("|",FALSE,D2:E2),TEXTJOIN("|",FALSE,$A$2:$B$6))))

This will not work if you can have "Apple|A" and "A|Apple".