title: Comparing and getting the corresponding row in excel
body: <p>I have 2 different excel data. 
  Sheet 1</p>
  
  <pre><code>S2_Symbol  S3_SymbolInteraction
  STE        AR1     Bind
  PRI        HYQ     Bind
  ILA        LOU     Bind
  VIS        IJK     Bind
  </code></pre>
  
  <p>Sheet 2</p>
  
  <pre><code>Symbol  
  STE       
  PRI      
  ILA        
  VIS
  LKY
  UTY
  SSG
  </code></pre>
  
  <p>I have to compare Symbol from 2nd sheet to S2_Symbol and S3_Symbol from sheet 1. If it matches any one of the columns in sheet 1, the corresponding entire row from sheet 1 should be my output.Can anyone help me with this? I've tried with VLOOKUP and Conditional formatting. I am trying with the following formula</p>
  
  <pre><code>=IF(OR(COUNTIF($A$3:$A$1003,I12)&gt;0,COUNTIF($B$3:$B$994,I12)&gt;0),**I12**,"not found")
  </code></pre>
  
  <p>Here i am getting only one value as output. How to get the entire column as output?</p>