title: Excel VBA: If A2="a","b","c",etc... then B2="aa"?
body: <p>I'm attempting to take the text in each cell of column A and assign a value to each cell in column B depending on the text in column A. For example, I have a list of versions that are identified by four-letter abbreviations of cities, and all of those versions are regionally assigned to different factories to be produced. So let's say I have an "AUST", "DAFW", "HOUS", and more versions all assigned to the location of "ARLINGTON". How would I most concisely use VBA to automate that once I have all the versions plugged in? Something like</p>
  
  <pre><code>If A2="AUST" Then
  B2="ARLINGTON"
  ElseIf A2="DAFW" Then
  B2="ARLINGTON"
  </code></pre>
  
  <p>I suppose something like this would work, however I can't believe that there's not a faster and more concise way. Does this make any sense? I've been pulling my hair out for about a week now trying to figure this out... Thanks for any help!</p>