Hello everyone,

I have been trying to figure out a way to compare a cell's content to a list, and if all the cell's content matches the list, return a True/False. I was hoping to avoid the text to columns solution if possible.

For example (and what the answer would be):

Cell Values
1,2,3 (True)
2,3,4 (False)
3,4,5 (False)
4,5,6 (False)
5,6,7 (True)
6,7,8 (True)
7,8,9 (True)

List
1,2,3,5,6,7,8,9

The cells have varying lengths, however. Some are only 2 values, through 162 values.

Thanks for any help you can provide in advance!

-SMB