List to List Comparison

[Squeaky Data]

I am not sure what to call this kind of comparison so I have had a hard time searching for any information.

I have two list that are used to manage record access security. One list is generated for extended privileges and the other is from field data.

List One:

London

New York

List Two:

New York

Toronto

London

I am trying to figure out a boolean calculation to see if ANY of the values in list one match ANY of the values in list two. Pattern count will only work if the lists are in the correct order so I think I need to figure out a recursive calculation to compare each value individually from list one against list two.

[comment]

Try the FilterValues() function.

[Squeaky Data]

Try the FilterValues() function.

Thanks, I just started to explore that and it looks like it should work.

Do you know if this type of match has a name?

[comment]

http://en.wikipedia.org/wiki/Intersection_%28set_theory%29