List of csv in a cell must match a range
I have a sheet with a cell in each row that contains a list of comma separated values. I want to evaluate this list against a a different sheet (sheet 2) and return true if the cell contents matches one of the columns of values in sheet 2. I don't even know where to begin.
ie, check that if of these values ==>
matches all the values of one of these columns ==>
and returns the name of the matching column.
Help Article Resources
Check out the Formula Handbook template!