title: Compare two columns and if match found check the next cell for a value and then return the result
body: <pre><code>COL1        COL2              COL3
  Hi          T_M12345678       T_455462    
              T_M12345670       T_M12345678
  bye         T_M123456781      T_M12345670
              T_M123            T_M589646
              T_M894545         T_M123456781
              T_M418554651      
              T_M4546565
  </code></pre>
  
  <p>I need to compare COL2 and COL3; if any match is found then I need to compare with COL1 for that match found and if there is any value in COL1 then it should return a value on below mentioned scenarios true in COL4.</p>
  
  <p>For Example,</p>
  
  <ul>
  <li><p>Scenario 1:
  Data <code>T_M12345678</code> is present in COL2 and COL3 so match is found then, I need to check whether I have any value in COL1 for this data in COL2 and in this case, it is YES (<code>Hi</code> is the value in COL1) so I should print <code>TRUE</code> in COL4. </p></li>
  <li><p>Scenario 2:
  Data <code>T_M12345670</code> is present in COL2 and COL3 so match is found; then I need to check whether I have any value in COL1 for this data in COL2 and in this case, it is NO so I should print <code>TRUE1</code> in COL4.</p></li>
  <li><p>Scenario 3:
  Data <code>T_M589646</code> in COL3 is not present in COL2 so I need to print <code>FALSE</code> in COL4.</p></li>
  </ul>