title: If cell equals with a value in another cell then cellX
body: <p>i am trying to use IF in the following arguement:</p>
  
  <p>I have a sheet with a list of products next to it a list with manufacturer. In each product corresponds to a certain manufacturer of the list.</p>
  
  <p>Now how i can tell a cell that if it found in the cell A1 on another sheet the a value from the list of products in the previous sheet to give me as a result the corresponded manufacturer.</p>
  
  <p>I tried the following as a test:</p>
  
  <pre><code>=IF(COUNTIF(B9;data!A:A);data!B:B;"product not found")
  </code></pre>
  
  <p>were B9 is the cell that i put the product manually, data!A:A is the range of the sheet that i have the list of the products and data!B:B is the list with the manufucturers.</p>
  
  <p>The syntax i guess is ok since its working properly in excel but the thing is that i get always (product not found). </p>
  
  <p>Could please someone help me? Thanks in advance!</p>