title: If column A's value is within the range of Column B and C then copy
body: <p>in this project i have to check column's A value between Column B and Column C. If  columnA's values>= Columns B value or Columns A value&lt;= Columns C value then i need to copy column d and e values and need to put into sheet1 column G and H. Column A is in sheet1 and Column B, C, D and E in sheet2.</p>
  
  <p>I am sorry with my wordings i know its difficult to understand. If someone can help me with this i would be forever grateful. Thank you</p>
  
  <pre><code>             A       B    c   D     E
               1       1    9   Dog   Naruto
               11      10   19  Cat   one piece
               21      20   30  Duck  lo 
  
  
  
            i want the outcome like this
             A    G       H
             1    Dog     Naruto   
             11   cat     One piece
             21    duck     lo
  </code></pre>