How to check if every word in a cell is in another column - Google Sheets

Question

Trying to see if every word in a given cell is in a list in another column. For example:

https://i.stack.imgur.com/SGdsU.png

Thanks in advance!

player0 · Answer

try:

=ARRAYFORMULA(COLUMNS(SPLIT(A9:A10, ", "))=
 LEN(SUBSTITUTE(FLATTEN(QUERY(TRANSPOSE(
 IFERROR(1/(1/REGEXMATCH(SPLIT(A9:A10, ", "), 
 TEXTJOIN("|", 1, A2:A5, "^$"))))),,9^9)), " ", )))

How to check if every word in a cell is in another column - Google Sheets

1 Answers