how to check if all values in a string is available in a list

[toxicboy]

I have a column id which I need to check if all values within that id per cell is available in another list of IDs

ex:

id

0786,0982,7923,A913

0389

0917,0982

7923,A913,0917

LIST

0786

0982

7923

0917

hence output will be:
1st id = FALSE, as A913 is not in list
2nd id = FALSE, as 0389 is not in list
3rd id = TRUE, as both 0917 and 0982 are in list
4th id = FALSE, as A913 is not in list

[niklas_greilinger]

Here is one way of doing this. PLease let me know if this helps you.

[rzdodson · Accepted solution]

@toxicboy here is another approach.

[Qiu · Accepted solution]

@toxicboy 
We can also go with the approach below.

[flying008 · Accepted solution]

Hi, @toxicboy 

FYI.

[caltang · Accepted solution]

Another way: