title: VBA/Function/Formula, IF for multiple instances
body: <p>say I have the following info:</p>
  
  <p><a href="https://i.stack.imgur.com/hoCVK.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hoCVK.jpg" alt="enter image description here"></a></p>
  
  <p>and so on for all of A, is there a way to call multiple values in col A so I don't have to keep changing the formula in Col B. Essentially its IF A = _ &amp; _ &amp; _ &amp; _  , I want it to change to _ &amp; _ &amp; _ &amp; _ in col B.</p>
  
  <p>thanks.</p>