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
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
so two field son the same record.

like

cats;dogs;parrots

and the other list is
fish;hamster;cats

so that would be TRUE because they both contain cats?


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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
    ------------------------------