title: Is there a way to store values, have vba search for the values within a column and paste a different set of text depending on the value?
body: <p>Just incase the title hasn't described this properly. So I'd like to store some a load of values in VBA (probably the first problem as I wasn't sure if I could store them as a list or an array properly), have it search for these values within a column and paste a different result in a different column depending on what was in the original column.</p>
  <p>For example:</p>
  <p>Column A
  Rich          Standard      Bumpers       Video Other   Snap Ad       Text Tweet</p>
  <p>Column B Display Display Video Video Social Social</p>
  <p>So far I've made an IF statement but it's going to be quite a long bit of code that I'd rather not have if this is possible without, but this is a small amount of what it looks like because it's a beastly bit of code with everything I need inside of it. Just incase it's relevant LastRow is just to make the code do it to the last row within the sheet that has text. Thanks in advance! :)</p>
  <pre><code>Sheets(&quot;GATE Digital Data&quot;).Select
  For Each Cell In Range(&quot;M5:M&quot; &amp; LastRow)
      If InStr(Cell.Value, &quot;Standard&quot;) Then
          Cell.Offset(0, -5).Value = &quot;Display&quot;
      ElseIf InStr(Cell.Value, &quot;Video Other&quot;) Then
          Cell.Offset(0, -5).Value = &quot;Video&quot;
  </code></pre>
  <p><a href="https://i.stack.imgur.com/GTR5o.png" rel="nofollow noreferrer">Example of current outcome</a></p>