title: Excel Power Query - add conditional column by looking up data from another Table
body: <p>I am looking to add a conditional column in power query by looking up data from another table.</p>
  <p>As an example, my lookup data is as follows:</p>
  <p><a href="https://i.stack.imgur.com/p5uNd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/p5uNd.png" alt="Lookup master Table" /></a></p>
  <p>My data is as follows:</p>
  <p><a href="https://i.stack.imgur.com/qM7RI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qM7RI.png" alt="Data" /></a></p>
  <p>Now I want to check if the number in my data is between Begin &amp; End of my Master data &amp; if the condition is satisfied, then I want to add a column by coping the corresponding &quot;Digits&quot; Cell to my Data. The result should look like this:</p>
  <p><a href="https://i.stack.imgur.com/hwlNe.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hwlNe.png" alt="Resulting Table after lookup &amp; adding column" /></a></p>
  <p>Can someone point me on how to do this?</p>
  <p>Any help is greatly appreciated.
  Thanks in Advance</p>