Match any part of multi select to another multi select on another sheet
I have two separate sheets that each have multi select columns and I want to join a particular column if it has ANY mutual matches between the two.
For example, on sheet 1, A B C are selected in the multi select and I want to find any matches on sheet 2 which contain anything selected from sheet 1. The column on sheet 2 is also a multi select column and can have any combination of these selected.
So if A, B, C are selected on sheet 1 and B, D, E are selected on sheet 2, this should trigger a match.
Help Article Resources
Check out the Formula Handbook template!