I have a few lists on a Google Sheet, each kept in a column of cells. One of the list is the Master list, and I would like to make sure that the elements in the other lists are also present in master.
list2 are valid, but
list3 is invalid because
x is not present in
Duplication is orthogonal to the question - I can use
UNIQUE if I'd like to check for uniqueness as well.
What Have I Tried
LOOKUPonly works for a single value and for sorted ranges
- Using Google Sheets Query Language: Did not find any set / list operations
How can I check whether all the values in an unsorted cell range exist in another cell range?