CODEWITHSUNDEEP
excelmatch
Shak
Shak

Reputation: 133

Match pair of cells with another pair of cells

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.

enter image description here

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

Upvotes: 0

Views: 609

Answers (1)

Ike
Ike

Reputation: 13064

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".

Upvotes: 1

Related Questions