Check if other strings exist in column based on range string values

Hi,

What I'd like to do is to detect if there are other string values in a column other than in the selection of strings in a range.

Example data:

Range Selection (A18:A27)
Name 1
Name 2
...


Column S
Name 1
Name 1
Name 2
Name 4
Name 2
Name 3
...

Output 1
True = if all text labels in Column S are equal to text labels of Range Selection
False = if there are text labels in Column S that do not appear in the Range Selection

Output 2
Provide an overview of the names that are in Column S that are not in the Range Selection

Let me know if you need more information,

Jeroen

Thanks for your response. I understand your solution, however I do not want to add any additional columns and then filter since column S is based on a different sheet which contains only 'raw' data that I do not want to alter.

Do you have a different solution, that just shows the output for all rows instead of filtering based on an index match function?