title: Create a new column that is filled with value from other table if it is found between range of 2 other columns in the other table
body: <p>Suppose I have the first data frame that looks like this (dfA)</p>
  
  <pre><code>CHR  POS  
  1    100    
  1    200    
  2    100
  2    200    
  </code></pre>
  
  <p>And I have another data frame that looks like this (dfB)</p>
  
  <pre><code>CHR  START  STOP  VALUE   
  1    0      150   1000
  1    200    300   2000
  2    0      300   3000
  </code></pre>
  
  <p>What I want to have is a new <strong>column</strong> in dfA if <code>dfA$POS</code> values are found within the range of <code>dfB$START</code> and <code>dfB$STOP</code>. Additionally, the first column must match with each other (dfA and dfB both have the same first column CHR).</p>
  
  <p>If found, the row in the new column in dfA will be filled with the value in <code>dfB$VALUE</code>.</p>
  
  <p>The result should look like this</p>
  
  <pre><code>CHR  POS  VALUE
  1    100  1000
  1    200  2000
  2    100  3000
  2    200  3000  
  </code></pre>
  
  <p>How would I go about doing this? Thanks for the help!</p>