title: Filter one list by another using power query
body: <p>I have a list of elemental impurities in power query which I wish to filter according to whether or not they exist on another list known as the prop65 list.</p>
  <p>The screenshot below shows a simplified example of what I am trying to achieve.</p>
  <p><a href="https://i.stack.imgur.com/RahJ1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RahJ1.png" alt="enter image description here" /></a></p>
  <p>I appreciate that using formulas However I don't know how to achieve this using a Power query solution. If anyone know how to achieve this it would be appreciated.</p>
  <p><strong>Data shown:</strong></p>
  <pre><code>Aluminium 33.885
  Antimony 0.6777
  Arsenic 3.5064
  Barium 2.259
  Boron 1.3554
  Bromoform 0.555
  Cadmium 3.18895
  Chromium 0.33885
  Cobalt 1.1295
  Copper 0.4518
  Indium 0.4518
  
  Simplified Prop65 List
  Arsenic
  Bromoform
  Cadmium
  Furan
  Lead
  Nafenopin
  </code></pre>