title: how to use vlookup in excel 2010 to search 2 variables
body: <p>elp</p>
  
  <p>I have below colum</p>
  
  <pre><code>A       B     C         
  CBL     20  21000   
  CBL     40  26580   
  CBL    40HC 25780   
  CIPL    20  18000   
  CIPL    40  20000   
  CIPT    20  21700   
  CIPT    40  26580   
  </code></pre>
  
  <p>when i do a vlookup, to search for CBL in another tab, I want it to also search column b, so it will shows the correct results from column C. </p>
  
  <p>CanI use vlookup or other formulae? </p>
  
  <p>pls </p>