title: Excel Formula If x in column B then y, Z, K..etc in Column A
body: <p>So basically I have a spreadsheet, with a list of names in column B. For this list of names I want to assign text to add into the adjacent cell in column A.</p>
  
  <p>I have tried </p>
  
  <pre><code>=IF((C:C="Name1", C:C="Name2"),"Text","")
  </code></pre>
  
  <p>However, this formula gives an error without any help.</p>
  
  <p>Can someone please solve this for me, or give me some information on how to solve it, as I need it to finish a project for work?</p>