title: How to use Google Sheets to categorise data, depending on text values in a column
body: <p>I ask this, as I previously performed this task using Python. I'm moving on to a new position and I need to pass this task over to someone who does not know how to program.</p>
  <p>I am hoping there is a simple and suitable Formula to use on Google Sheets.</p>
  <p>in the following table on Google Sheets:</p>
  <p><a href="https://i.stack.imgur.com/B5UN1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/B5UN1.png" alt="enter image description here" /></a></p>
  <p>Is there a <strong>formula I could use to automatically categorise that data?</strong></p>
  <p>ie in pseudocode</p>
  <hr />
  <p>If Column A contains &quot;password&quot; or &quot;sign in&quot;:</p>
  <p>Column B = &quot;Account Access&quot;</p>
  <p>Else If</p>
  <p>Column A contains &quot;support&quot; or &quot;contact&quot;:</p>
  <p>Column B = &quot;Customer Support&quot;</p>
  <hr />
  <p>Etc for multiple other categories.</p>