title: How to match with common cities visited in
body: <p>The goal is to match the special and the normal and the condition is that they have a common city. The special's name should appear in Column E and the Normal's name should appear in Column F and they're being matched because they both are in the same city or have visited the same city.</p>
  <p>So the data dump that, um, will be updated on a daily basis. So for example, Type Special - Caroline has visited in Cambridge. If there's also a Type Normal that has visited Cambridge. Hence both visited Cambridge and that's why they were matched.</p>
  <p>All right. Another example is, um, let's see here, Regina. Is a special type. Now we want to match her with a type Normal. So in this case, there are no matches, so that would not appear in the outcomes.</p>
  <p>Only those who have been tagged as a Special or a Normal can be matched. So the match always has to be between Special and Nornal and their names just have to appear here at the visited city.</p>
  <p>Using FILTER Function thought it would work out, that will automatically detect a Special and a Normal when there is a common keyword in a city that they visited in, but it isn't working.</p>
  <p><a href="https://i.stack.imgur.com/kpgQE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kpgQE.png" alt="IMAGE" /></a></p>
  <p><a href="https://docs.google.com/spreadsheets/d/1cJr5PT4QDspxJkpgCFIK6K0hDlCQx3DhT9VUjba2nmw/edit?usp=sharing" rel="nofollow noreferrer">GoogleSheets</a></p>