Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago

Check to see if a value in one list, is contained in another list

How would I search through one list and see if any of those values are contained in another list? Then return it as a formula checkbox, or formula text, the output doesn't matter I can deal with th...
Formulas and functions
MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago
Correct. It's TRUE if ANY of the words in list 1, is contained in list 2.

In my case it's two lists of dates.

------------------------------
Mike Tamoush
------------------------------
MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago
Bonus points if you can return every duplicate in a text list. So instead of returning true, return a list of each item in list 1 that is contained in list 2.

My gut says I need to use the Part function and just manually create a formula with the max number of items I believe will be in list 1.
------------------------------
Mike Tamoush
------------------------------